Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This is what I use on one of my sheets. Basically the user double clicks on a cell to bring up a user form; and it highlights the cell yellow when they submit their correction. If they make a mistake then they double-click to remove the highlight. You should be able to just pull out the middle of the code below for what you need.</p> <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Application.EnableEvents = False Dim TargRow As Variant Dim TargCol As Variant TargRow = Target.Row TargCol = Target.Column Header = 8 FirstCol = 0 LastCol = 13 CommentCol = 13 If TargRow &gt; Header And TargCol &gt; FirstCol And TargCol &lt; LastCol Then 'If the cell is clear If Target.Interior.ColorIndex = xlNone Then Cancel = True 'Then change the background to yellow Target.Interior.ColorIndex = 6 Corrections.Show 'Else if the cell background color is already yellow ElseIf Target.Interior.ColorIndex = 6 Then 'Then clear the background Target.Interior.ColorIndex = xlNone End If End If 'This is to prevent the cell from being edited when double-clicked Cancel = True Application.EnableEvents = True End Sub </code></pre> <p>EDITED CODE per comments below:</p> <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'If the target cell is clear If Target.Interior.ColorIndex = xlNone Then 'Then change the background to the specified color Target.Interior.ColorIndex = 4 'But if the target cell is already the specified color ElseIf Target.Interior.ColorIndex = 4 Then 'Then clear the background color Target.Interior.ColorIndex = xlNone End If End Sub </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POchange color of cell with mouse click
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJon
    1. USJon
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for your reply, but I'm still having problems. I'm trying to apply this to specif cells. What I have now is as follows:
      singulars
      1. PO
      1. USCharles Girardi
    2. COOk. I chopped down what I have above and changed where to put it. The code is placed as a SelectionChange event on the worksheet. It only requires you to click a cell (not double click like above); clicking the cell turns the cell green - single-clicking the cell again clears the color. Also, the cells can still be edited unlike my original answer above. See edited answer above for code.
      singulars
      1. PO
      1. USJon
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload