drop down list of available tables in a database

B

bobmc

Board Regular
Joined
Mar 13, 2002
Messages
142
Is there a way to define the source of a dropdown list to show available tables in a database?

Any help is appreciated!

bobmc
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Sort by date Sort by votes
You could probably have a macro run to get that information. What kind of a database are we talking about? Is the database in a fixed location? Is the workbook to be used on different computers, and if it is, do they all have access to the database using the same path?
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Dynamic dropdown list based on database
Replies
3
Views
219
Winnetou
W
M
  • Question
How to track choices in a workbook from several drop down lists and reflect the running choices throughout the month
Replies
0
Views
67
mellojeff
M
I
  • Solved
Add value to my database if not currently in drop down liast
2
Replies
16
Views
246
ipbr21054
I
R
  • Question
VBA Loop Through Data Validation Drop Down List
Replies
5
Views
446
rlv01
R
I
  • Solved
Type in field to jump to first instance of what was typed from a drop down list
2 3 4
Replies
38
Views
929
ipbr21054
I

Forum statistics

Threads
1,215,561
Messages
6,125,533
Members
449,236
Latest member
Afua

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top