Find table row source advice

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,884
Office Version
  1. 2007
Platform
  1. Windows
On my userform i have a drop down list where in the properties i see Table 48
I know which sheet its on but im having to click on a header then through one by one until i find Table 48

Please advise a quicker to to find it.

The table in question was in column ET so you can see how many clicks i had to do.

Thanks
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Unless I am misunderstanding the question, there are multiple ways of getting to the table quickly.
They are a Named Range so you can access them by:
1) Press <F5> or Ctrl+G (go to).
Then select the table name from the list.
2) Go to the Name Box in the top left corner. (the box that shows the current cell address)
Click on the drop down box and select the Table name from the list.
 
Upvote 0
Solution
Maybe I didn’t explain it clear.

In the design page I click on the combobox, right click & select properties. This is where you can alter width height colour etc etc.
Under row source I think it was it shows Table 48
 
Upvote 0
I understand that you have the row source as Table48 (a table name can't have a space in it). What is the question ? What are you wanting to do ?
 
Upvote 0
See screenshot

EaseUS_2025_01_24_12_02_24.jpg
 
Upvote 0
Your initial question appeared to be how to find where Table48 actually is. Alex has answered that.

If that was not your question, what is?
 
Upvote 0
Ah ok i thought i was doing it from my design page & couldnt see a name box but didnt relise i have to go to the actual sheet.

Now i see it thanks.
 
Upvote 0

Forum statistics

Threads
1,226,067
Messages
6,188,700
Members
453,493
Latest member
BRACE

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