Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Formating a cell to auto populate
We are trying to set up an excel spreadsheet that has several check boxes and
we want to set it up to populate the box with an "X" when a user clicks or double clicks on the cell. How can we accomplish this? Any help will be appreciated. -- Aldo |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Formating a cell to auto populate
This coding is for cells B1 thru B10, modify it to suit your needs:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Set r = Range("B1:B10") If Intersect(Target, r) Is Nothing Then Exit Sub Target.Value = "X" Cancel = True End Sub Because it is worksheet code, it is very easy to install and use: 1. right-click the tab name near the bottom of the window 2. select View Code - this brings up a VBE window 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To remove the macro: 1. bring up the VBE windows as above 2. clear the code out 3. close the VBE window To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm To learn more about Event Macros (worksheet code), see: http://www.mvps.org/dmcritchie/excel/event.htm -- Gary''s Student - gsnu200756 "Aldo" wrote: We are trying to set up an excel spreadsheet that has several check boxes and we want to set it up to populate the box with an "X" when a user clicks or double clicks on the cell. How can we accomplish this? Any help will be appreciated. -- Aldo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
How do I Auto Populate a cell with a chart based on a value | Excel Worksheet Functions | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Simple question - auto populate cells - dependent on other cell value. | Excel Discussion (Misc queries) | |||
Auto Populate a cell | Excel Discussion (Misc queries) |