Use option button to populate textbox from table value

**AndyE** · 02-24-2015, 04:32 AM

Hi

Apologies, I'm sure this is very simple...

I have a table in Sheet1 which only has two columns A - containing a part number and B - part description.

I have two textboxes (A and B) and an option button,

I want to type the part number into Textbox A and then press the option button to display the part description in Textbox B.

How can I code that?

Thank you,

**Fotis1991** · 02-24-2015, 04:47 AM

try

=

Please Login or Register  to view this content.

**AndyE** · 02-24-2015, 04:58 AM

Thanks for the reply, however that just copies the data from one textbox to the other...

What I need is to key in a part number (from Column A in the worksheet table) into Textbox A and when the button is clicked the corresponding part description (from Column B in the worksheet table) is displayed in Textbox B.

The textboxes are in a userform.

cheers,

**Fotis1991** · 02-24-2015, 05:15 AM

a small worksheet example will help us to help you.

**AndyE** · 02-24-2015, 05:24 AM

ok, sorry. File attached...

**Fotis1991** · 02-24-2015, 06:02 AM

1 way could be this.

Please Login or Register  to view this content.

**AndyE** · 02-24-2015, 06:19 AM

That'll do nicely.

Thank you

Use option button to populate textbox from table value

LinkBack

Thread Tools

Rate This Thread

Display

Use option button to populate textbox from table value

Re: Use option button to populate textbox from table value

Re: Use option button to populate textbox from table value

Re: Use option button to populate textbox from table value

Re: Use option button to populate textbox from table value

Re: Use option button to populate textbox from table value

Re: Use option button to populate textbox from table value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Textbox and Option Buttons - If Textbox has a Value then an Option Button must be selected

[SOLVED] Help With Using Option Button and Textbox with A Command Button

[SOLVED] option button to disable textbox

Using an Option Button to send a textbox value to a cell

[SOLVED] passing Option button result to textbox

Bookmarks

Bookmarks

Posting Permissions