Someone helped me with the code below and it worked while I had it placed in a spreadsheet. I tried moving it to a standard module and it will no longer work tells me invalid use of Me. How can I populate these two combo boxes at start up?
Please Login or Register to view this content.
Last edited by randell.graybill; 06-04-2009 at 11:49 PM.
Additional information:
The data for the combo boxes comes from "U:\DOH.xls"
Combo Box 1 the range is A2:A200 (some of which might be blank)
Combo Box 2 the range is D2:D200 (some of which might be blank)
This is the last bit of help I need on this project I am thankful all the help you have given me and my other projects. This one tracks what time someone gets a unit what time they log-n to start using it.
Basically all it does is open the spreadsheet U:\DOH.xls silently, Fill combo box 1 with range a2:a200 from DOH.xls and fill combo box 2 with range d2:d200 from doh.xls.
The spreadsheet should open and close silently so the user can't see it opening and closing.
Can anyone help with this?
Last edited by randell.graybill; 06-04-2009 at 11:29 PM.
Replace Me with the sheet you want it to refer to
orPlease Login or Register to view this content.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
OMG I can't believe that was all I had to do wow thanks a bunch. works like a charm.
only had to make one very minor change see below. The name of the sheet changes.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks