Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
From Cell to InputBox
Greetings !
My code, after a "button" is pressed, throws an InputBox onto the screen. I want in reply to insert a value already displayed in a Cell. This I can do by selecting the cell before hand, pressing F9 and then Ctrl C followed by Esc. Then I click on the "button", and press Ctrl V at the InputBox. That's fine for one value, but the InputBox is followed by another, into which I want to paste the value from another cell. Yes, I COULD type it in - but that's not a satisfactory solution ! I guess one way would be to type in the Cell Reference - but is there a way that I could click on the required Cell ? There are ocasions when (say) "G72" would be a valid answer, when I actually want the VALUE in that Cell (which might be "J136", say) RClay AT haswell DOT com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning a cell address in a msgbox, by selection via inputbox Ty | Excel Discussion (Misc queries) | |||
InputBox to select cell locations | Excel Worksheet Functions | |||
Inputbox with VBA | Excel Discussion (Misc queries) | |||
Inputbox used to return value of selected cell | Excel Programming | |||
Inputbox to return address of cell selected by mouse | Excel Programming |