Tronsliver
Technical User
Hopeing someone can assist. I would like to send the contents of a list box to Excel. Is this possible? If so, I sure would appreciate some assistance as to how.
Thanks
Roger
Thanks
Roger
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sending contents of listbox to Excel
- Thread starter Tronsliver
- Start date
- Status
The following should be of some help:
Your listbox is based on a table/query and the data being transfered is the cell information.
HTH
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Your listbox is based on a table/query and the data being transfered is the cell information.
HTH
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
- Thread starter
- #3
Tronsliver
Technical User
What I'm hopeing to accomplish is to build a command button that sends the contents of the list box to Excel when selected?
Unfortunately, I don't know how your list box is set up. Is it bound or not, what is the control source. Number of items in the list, how the data is getting there etc.
Have you considered using a combo box instead. Check help to see the differences. Type in list box and look for Should I create a list box, a combo box, or a drop-down list box?
Hopefully, after reading this, it will give you some ideas.
HTH
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Have you considered using a combo box instead. Check help to see the differences. Type in list box and look for Should I create a list box, a combo box, or a drop-down list box?
Hopefully, after reading this, it will give you some ideas.
HTH
An investment in knowledge always pays the best dividends.
by Benjamin Franklin
- Status
Similar threads
