Struggling to refer to a named range on a specific sreadsheet

[jancliff]

I have an excel form I am creating.

The user has asked for two radio buttons called Goods1 and Goods2

If the user ticks Goods1 a field on the form called txt_Goodsname will lookup what is held in a spreadsheet called "LookupLists" in call M3 (named range Goods1) and return that name.

If the user ticks Goods2 the field on the form called txt_Goodsname will lookup what is held in a spreadsheet called "LookupLists" in cell N3(named range called Goods2)
and return that name.


I'm a little new to this and tried writing some code on the click of radio button 1

Please Login or Register  to view this content.

Unsurprisingly it doesn't work. I would greatly appreciate any pointers in the right direction.

Many thanks

[6StringJazzer]

Let's try this. You said that there was a range named Goods1 but you haven't used that name in your code. We'll take advantage of it here:

Please Login or Register  to view this content.

[jancliff]

Let's try this. You said that there was a range named Goods1 but you haven't used that name in your code. We'll take advantage of it here:

Please Login or Register  to view this content.

That worked a treat. But if the user changes their mind and goes and clicks from one radio button to another it doesn't seem to refresh. Should I be looking at clearing the field before?

Many thanks for all of your help

[jancliff]

Aah , I think I need to work on it as it is changing the value in the worksheets LookupLists and not in the form. Will do some further research but I have got further so that's great thanks

[6StringJazzer]

You need another

Please Login or Register  to view this content.

that looks like this one but refers to Goods2.

For more comprehensive help, attach your file.