List Box Source

D

dfenton21

Board Regular
Joined
Jun 23, 2007
Messages
135
Hi,

Is there any way of returning the cell address of a listbox value source in VBA, e.g. rowsource = A1:A20. The value of A3 = red. When red is selected in the listbox, A3 is returned.

Thanks,
Damien.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Hi Damien,

Something like this should work:

Code: 
c = Range("A1:A20").Find(What:=ListBox.Text, LookIn:=xlValues).Address

You'll need to edit the ListBox details to suite yours, but c should have the address.

ColinKJ
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Help w/creating cascading listboxes
Replies
3
Views
97
Micron
M
R
  • Question Question
How to Paste a Single Column of ListBox Values to Sheet Across a Row
Replies
4
Views
220
Akuini
Akuini
M
  • Question Question
Re-produce code to copy last row from listbox on userform to sheet
Replies
3
Views
155
MKLAQ
M
J
  • Question Question
Listbox rowsource in personal working folder
Replies
1
Views
301
NateSC
NateSC
C
  • Question Question
Changing the Rowsource of a userform Listbox with each change in the Listbox selection
Replies
0
Views
495
chazrab
C

Forum statistics

Threads
1,224,575
Messages
6,179,637
Members
452,934
Latest member
Jdsonne31

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