Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() -----Original Reply from Tom Ogilvy----- You said you had 4 inputboxes that received boolean values. I **asked** You want to replace your four input boxes with a userform with 4 optionbuttons? "Userforms" are "terra incognita" to me, alas.... and I would prefer to avoid yet another learning curve.... Your first example of getting a date has nothing to do with boolean values. Erm... yes, sorry - I guess that was a bit of a red herring - but indicated my current "thought process" If you are only going to get one response, then you should probably use a msgbox. Then the user only has to click, not type in a value. Ah. Thank you. Dim IWantNewer as Boolean IWantNewer = InputBox("Do you want " & _ "newer files, " , vbYesNo) = vbYes Looks just the job. I have four such Boolean questions, and thought that four buttons on screen at once might be easier for the user than four consecutive MsgBoxes. But I guess you're right. Yet again ! <grin Thank you very much. Again ! RClay AT haswell DOT com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
userform | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
Userform | Excel Programming | |||
userform | Excel Programming | |||
userform | Excel Programming |