| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I click on a cell and enter a default value?
I would like to be able to click on a cell and have a value automatically
entered. I would like this to work like a forms control checkbox. Or is my only answer use the control checkbox? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I click on a cell and enter a default value?
Try using
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$E$2" Then Target = 234 End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "pawlingJohn" wrote in message ... I would like to be able to click on a cell and have a value automatically entered. I would like this to work like a forms control checkbox. Or is my only answer use the control checkbox? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I click on a cell and enter a default value?
Don,
Thanks for the quick reply but i have never worked with VB and am not sure what to do once I put the code in. "Don Guillett" wrote: Try using Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$E$2" Then Target = 234 End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "pawlingJohn" wrote in message ... I would like to be able to click on a cell and have a value automatically entered. I would like this to work like a forms control checkbox. Or is my only answer use the control checkbox? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I click on a cell and enter a default value?
Opps!!! I have to put the X in quotes.
Thanks a millions Don. "Don Guillett" wrote: Right click the sheet tabview codecopy/paste this. Now when you select cell E2 the number 234 will appear in that cell. -- Don Guillett Microsoft MVP Excel SalesAid Software "pawlingJohn" wrote in message ... Don, Thanks for the quick reply but i have never worked with VB and am not sure what to do once I put the code in. "Don Guillett" wrote: Try using Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$E$2" Then Target = 234 End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "pawlingJohn" wrote in message ... I would like to be able to click on a cell and have a value automatically entered. I would like this to work like a forms control checkbox. Or is my only answer use the control checkbox? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I type data into a cell that changes when I click enter - why? | Excel Discussion (Misc queries) | |||
| How to make the current date appear when i click 'enter' in a cell | Excel Worksheet Functions | |||
| Enter Text in Cell on Click | Excel Programming | |||
| enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
| WHY DO I HAVE TO CLICK ON THE CELL & ENTER FOR THE VLOOKUP TOWORK | Excel Discussion (Misc queries) | |||
Hybrid Mode
