Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using inputBox to assign multiple variables and then assigning
the info from those variables to cells which I then reference from another macro. What I'm finding is that as already noted here in another thread: "There is another Inputbox function in VBA which returns an empt string if cancel is pressed." This is what seems to be happening if I hit either 'Cancel' or 'Enter'. What I'd like to do, is afford the user the opportunity to change not all or lose all, but to be able to change just some of the information. Is there a way with multiple variables to change just some of the variables but not all without erasing previously entere information by hitting 'cancel' or 'enter'? Thanx -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning a cell address in a msgbox, by selection via inputbox Ty | Excel Discussion (Misc queries) | |||
Returning Data to an empty Cell | Excel Worksheet Functions | |||
Returning an empty cell when no data present | Excel Discussion (Misc queries) | |||
VBA function returning the value EMPTY | Excel Programming | |||
String length of Inputbox user input. | Excel Programming |