Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good afternoon again.
I have been tinkering with the code examples that have been provided from yesterday and I have come to a snag in the road, although it mostly works, I am unable to get the toggle button to act as a password prompter, I'd appreciate some assistance with the coding if anyone is able to help. Here is the code I am using now and when I click the toggle button to prompt for a password, an error comes up with no block if without end if? I am confused as to what VB is thinking it should be seeing as there are two if block statements and two end ifs. Am I missing something simple? Private Sub ToggleButton1_Click() Dim x As String x = InputBoxDK("Type your password here.", "Password Required", "test") If x = "test" Then ToggleButton1.Value = True If ToggleButton1.Value = True Then ' ' ToggleButton1.Caption = "Refresh Enabled" StartTimer Else ' ' ToggleButton1.Caption = "Refresh Disabled" End If If x < "test" Then MsgBox "You didn't enter the correct password to turn off the refresher." End End If End Sub Thanks for your time with my learning curve. Jessica |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Part of the screen has blank spots (not refreshing properly) | New Users to Excel | |||
Part of the screen has blank spots (not refreshing properly) | Excel Discussion (Misc queries) | |||
spreadsheet part and part without grid lines | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
How can I sperate the module into two part and connecte the two part and work well? | Excel Programming |