| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the Correct Data Type?
The code below keeps failing.
Dim i_pwd As Variant i_pwd = InputBox("Please Enter Password to Unhide Sheet", "Unhide Sheet...") If i_pwd = "" Then Exit Sub End If Select Case LCase(i_pwd) Case Is = "ryan72" Worksheets("Ryan - Summary").Visible = True Sheets("Ryan - Summary ").Select A message pops up saying, 'Incorrect Password...' I know the password is correct, I am not sure about the Data Type though. Can someone please give me some guidance? Thanks so much, Ryan--- -- RyGuy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filtering he data is not always correct | Excel Programming | |||
| Comparing Data (Im not sure if that is the correct tern) | Excel Discussion (Misc queries) | |||
| Check a column for correct type of data | Excel Programming | |||
| Import data not in correct format | Excel Discussion (Misc queries) | |||
| Pivot table converts data to a 1,2,3 how do I get data to correct | Excel Discussion (Misc queries) | |||
Threaded Mode
