Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Howdee all.
I have a macro that I've got a variable that presently requires either a true, or false input. This macro calls to another function, which only requires an input if the element is true. I'd like it to only require an input if the statement is true. I just tried- MyVar = Application.InputBox(Prompt:="Is this a font color?- True or False", Type:=4) If MyVar= "" Then MyVar = False Else: MyVar = True End If I receive a type mismatch error when I do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set Boolean Variable for Changing Any Control on Userform | Excel Programming | |||
Boolean Variable Definition | Excel Programming | |||
More on Boolean | New Users to Excel | |||
VBA Boolean | Excel Discussion (Misc queries) | |||
UserForm not passing Boolean variable | Excel Programming |