Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Log-In Screen Code Won't Work
Can someone review my code and see why my Log-In userform code will not work properly? I can't get the Log-In form to redisplay each time the user inputs the wrong USERNAME and PASSWORD. After the inital log-in attempt, code loops two more time, but never re-displays the log-in form for the...- MsBecca
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run-time Error 1004 - Method 'Range' of object '_Global' failed
Could someone review my attached code and let me know why I am receiving the "Method Range of object_Global failed". Comboboxlist is a named range (Thanks to SkipV for tip): =OFFSET('Contract DB'!$IV$2,0,0,COUNTA('Contract DB'!$IV:$IV)-1,1) Column IV on my Excel worksheet contains...- MsBecca
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ComboBox: Add user entered text to combobox list
How do I add text that a user enters in a combobox to its already existing list? My combo box drop-down list is populated with data contained in an Excel worksheet range of (IS1:IS255). ROW SOURCE PROPERTY is set to this range. How do I then add user entered text into my combo box list so that...- MsBecca
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
