03856me
Active Member
- Joined
- Apr 4, 2008
- Messages
- 297
I believe this is possible, because you guys can figure out anything!
I have an Excel database that contains many userforms with textboxes (filename = master1.xlsm). Based on the value in txt_date on Frm-Import, I would like to be able to retreive data from another Excel database and import values into textboxes on the userform. Something like this:
txt_date value = 05/16/2011 and once I would press macro button it would import like so:
it would look for the date in c:\filename\Table1[date] and import from that row into the following:
textbox1 = import from c:\filename\Table1[Hours]
textbox2 = import from c:\filename\Table1[SThrs]
textbox3 = import from c:\filename\Table1[OThrs]
textbox4 = import from c:\filename\Table1[Rate]
Is this possible? If yes, could someone point me to some code that would get me started. I have researched the web and several site, including Mr.Excel and can't find anything close to this.
Thank you for helping,
I have an Excel database that contains many userforms with textboxes (filename = master1.xlsm). Based on the value in txt_date on Frm-Import, I would like to be able to retreive data from another Excel database and import values into textboxes on the userform. Something like this:
txt_date value = 05/16/2011 and once I would press macro button it would import like so:
it would look for the date in c:\filename\Table1[date] and import from that row into the following:
textbox1 = import from c:\filename\Table1[Hours]
textbox2 = import from c:\filename\Table1[SThrs]
textbox3 = import from c:\filename\Table1[OThrs]
textbox4 = import from c:\filename\Table1[Rate]
Is this possible? If yes, could someone point me to some code that would get me started. I have researched the web and several site, including Mr.Excel and can't find anything close to this.
Thank you for helping,