maybe i do need to be more specific
whatever is selected from the dropdown list, I want to display certain
text from other cells in a label, thats all
Here's what I have:
Sub DropDown26_Change()
'R1 Inventory
If Reagent_Drop_Down = "='Total Inventory'!A5:A62" Then
R1 = "='Total Inventory'!C5:C62"
Else
R1 = ""
End If
End Sub
R1 is the Label name
I'm sure this is way off, but I haven't programmed in
VB since high
school
so any help is greatly appreciated
--
malik641
------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread:
http://www.excelforum.com/showthread...hreadid=378607