LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default VBA ComboBox SetItemData type feature?

Yes, that was my next suggestion. If you set the columnwidth equal to the
combo width it gets hidden, but there is still a horizontal scrollbar.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Jones" wrote in message
...
In this case, I want to retrieve company names and their associated ID's
from the a database. It is a lot cleaner to be able to do other queries
based on the ID, because I can get to other tables directly. Example:
ask for all employees in a company by ID--the company name, of course,
isn't in the Employee table).

I think I've figured out my answer: you use multicolumns and put your
data in one of the columns, then hide it. Not too great, but it'll work
(I think).

Seems like people would run into this problem all the time.


What exactly do you want to retrieve? The combobox has a Listindex which
maybe you could use.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
Adding new 'Type' to Format->Number->Time->Type Chip Pearson Excel Discussion (Misc queries) 5 September 26th 05 08:45 PM
Autofill type feature. brookdale Excel Worksheet Functions 3 June 28th 05 10:47 PM
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox Minitman[_4_] Excel Programming 3 October 26th 04 07:58 PM
Userforms: combobox.value type Marcotte A Excel Programming 1 June 30th 04 12:41 AM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"