Hello again.....
Why would this code not work? i had it workign fine last week but had to populate different combo boxes with different ranges so created extra codes to do this, but had to add rngdate1 and ws1 etc as it can not duplicate rngdate and ws, but now none of the combo boxes are being populated with the ranges....
Dan
Please Login or Register to view this content.
see your other post for reason
Ok i changed Userform1 back to Userform and it works fine... But wasnt before, there is no other code in place yet that shoud cause any errors, the next code to perform is when the user clicks the add control once the user has completed the userform...
post example of non working file
Ok, i think ive screwed it right up now....
It wont let me upload the file im getting this message
407 [IOErrorEvent type= "ioError" bubbles=false cancelable=false eventPhase=2 text= "Error #2038"]
I had to disable the enhanced attachments
did that file fail for you?
Works as expected for me
At first yes, then it worked ok, well opened up the userform and populated the combo boxes, havent got to the part of checking its going into the right cells yet, and then it failed and said it was out of range....
And it works for you? I think im having a bad day!!
I pressed the button multiple times without error. Comboboxes populate and no error is raised.
Ok, im now not getting an error message, but there should be a message on pressing the "update rates" button which says "New rates have been added" and it dont
You only get a msgbox if all combobox values have been selected, due to the Exit sub codes.
Ah that explains whyok great thanks for your help Andy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks