Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
xz xz is offline
external usenet poster
 
Posts: 2
Default how to get Excel 07 combobox to populate from MS Access table?

I'm new to Excel & VBA programming (more familiar w/ .NET, Oracle
etc).
I have a new Excel doc & I threw down an Active-X combobox. Couple
questions:

1. I suppose the Active-X controls are more robust / easier to work
with.
2. Will those Active-X controls work with users that have Excel 2003
if I saved my file as an Excel 2003 xls file?
3. How can I get my combobox to populate from an Access database
sitting on a shared network drive?
4. If I can't dynamically query Access, how do I get that active-X
combobox to populate? E.g, I see something called listFillRange - I
guess I gotta create another worksheet, throw my 'lookup' data there,
and then put the range into that field.

What a *pain* !
Thanks for any help.

XZ
Reply
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
Access items stored in combobox Geoff Excel Discussion (Misc queries) 1 September 5th 07 01:58 AM
Access macros in Excel - populate results in spreadsheet Dawn Excel Discussion (Misc queries) 3 August 28th 07 12:30 AM
enter a value and have excel populate a table with that many rows Dave F Excel Discussion (Misc queries) 1 September 18th 06 02:06 PM
How do i populate a text box according to selection in combobox? Steve Excel Worksheet Functions 0 April 13th 06 12:40 PM
Using Access database to "populate" Excel Sheets maacmaac Excel Discussion (Misc queries) 1 September 19th 05 05:06 PM


All times are GMT +1. The time now is 07:27 PM.

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

About Us

"It's about Microsoft Excel"