LinkBack URL
About LinkBacks
laduk 
this is the code im trying to use
if me.namebox.Value = sheet3.Cell.b1 then me.brix.Value = range.("brix")
cheers
this is the code im trying to use
if me.namebox.Value = sheet3.Cell.b1 then me.brix.Value = range.("brix")
cheers
try
where "brix" is a named range?
If Me.namebox.Value = Sheet3.Range("b1").Value Then Me.brix.Value = Range("brix").Value
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please clickto give reputation
Read the FORUM RULES
brix is a range on sheet 1, i dont get any errors now but it dont pick up the range either
cheers
this is the sheet I am trying to use the code
cheers
The range brix seems to be all of column B. And me.brix is a combo box.
Are you trying to add all items in column B to your combobox?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
yes as long as namebox = sheet3 cell b1 or column c if namebox = sheet3 cell b2
thanks
Last edited by laduk; 07-09-2013 at 08:23 AM.
Try: (untested)
If Me.namebox.Value = Sheet3.Range("B1").Value Then Me.brix.List = Sheets(3).Range("brix").Value
no sorry still not working
thanks
Hi Laduk..
namebox is a label.. and I dont hink.. there was any CHANGE event for label..
and secondly.. BRIX range is Complete B:B.. try to avoid it..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Great thanks so simple now a text box and works
thanks all
happy to Help..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks