uwlchemist
New Member
- Joined
- Aug 29, 2009
- Messages
- 38
I have a routine that imports Excel data into an access form. It works great when the data is located in Cells. I decided to explor using comboboxes in excel to allow users to select data, and am not having a hard time importing that data into my access form. This is the typical code I use to import the data
frm.txtTargetRotationRate = XlSheet.Range("TargetRotationRate")
When I try the same thing using the combobox, I get an error saying thet the control does not exist...but it does (have checked everything multiple times)
frm.txtFilmTime = XlSheet.cmpFilmPersistency
How do I refer to the Excel combobox and the data within it?
frm.txtTargetRotationRate = XlSheet.Range("TargetRotationRate")
When I try the same thing using the combobox, I get an error saying thet the control does not exist...but it does (have checked everything multiple times)
frm.txtFilmTime = XlSheet.cmpFilmPersistency
How do I refer to the Excel combobox and the data within it?