Thanks RobBroekhuis and TheBitDoctor for responding and helping me resolve my coding problem.
Your help was much appreciated. STARS to both of you.
MsBecca
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...
Rob,
All of the above code is currently being executed in the cmdPrintEnterClearRec click event. There is only one worksheet in the "ContractDB" workbook that the information is being dumped into. This same worksheet also holds my values for the cboAgrT combobox, but in Column IV...
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...
Sorry Skip...Don't mean to be a pest, but I adjusted my code as you requested, now I am getting the following error message:
Run-time Error 1004 - Method 'Range' of object '_Global' failed
I've even tried putting the With...End Loop in the Combobox.Change Event and still get the same error.
I...
Skip Vought
Thanks for replying to my post, but I still cannot get the code to work. Where do I put the While....End Loop? Any help you provide me would be greatly appreciated.
Here is my current code w/your code added where I thought it should go:
Private Sub cmdEnterPrintClearRec_Click()...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.