| 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?
Thanks Don. One more question. If I put an "X"instead of a number it
doesn't insert anything. "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? |
|
#6
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I click on a cell and enter a default value?
Glad you got it figured out.
-- Don Guillett Microsoft MVP Excel SalesAid Software "pawlingJohn" wrote in message ... 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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I click on a cell and enter a default value?
One last question. How can i do this so that only a click will insert the
desired input. Now whenever i tab past the field the value goes into it. "Don Guillett" wrote: Glad you got it figured out. -- Don Guillett Microsoft MVP Excel SalesAid Software "pawlingJohn" wrote in message ... 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? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I click on a cell and enter a default value?
You could use a double-click event instead.
Private Sub Worksheet_BeforeDoubleClick(ByVal _ Target As Range, Cancel As Boolean) If Target.Address = "$E$2" Then Target = 234 Cancel = True End Sub Gord Dibben MS Excel MVP On Mon, 26 Jan 2009 13:42:33 -0800, PawlingJohn wrote: One last question. How can i do this so that only a click will insert the desired input. Now whenever i tab past the field the value goes into it. "Don Guillett" wrote: Glad you got it figured out. -- Don Guillett Microsoft MVP Excel SalesAid Software "pawlingJohn" wrote in message ... 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) | |||
Linear Mode
