Editable Active X Textbox Linked to Active X List Box

**bowater** · 12-08-2016, 05:18 PM

Hi all,

I suspect this should be pretty simple, I would like to be able to populate a text box based on a selection made in a list box and the textbox be editable. So I have a list box already linked to ListFillRange A1 to A4, and I can link the text box to B1 but how can I link the text box to the list box for a dynamic result? Below is an example of the data.

A1:2016 | B1: Please enter text here
A2:2017 | B2: Text has been entered here
A3:2018 | B3: 2018 will be a great year...
A4:2019 | B4: 2019 will be...

Thank you in advance for any help! I have tried Google but can not find a solution that allows the text to be editable.

Bowater

**bowater** · 12-08-2016, 07:44 PM

I found a solution by customising VBA that set the textbox value to instead set the textbox LinkedCell, see below:

Private Sub ListBox1_Change()
TextBox1.LinkedCell = "'Constants - do not amend'" & "!" & Range("B" & ListBox1.ListIndex + 1).Address
End Sub

Bowater

Editable Active X Textbox Linked to Active X List Box

LinkBack

Thread Tools

Rate This Thread

Display

Editable Active X Textbox Linked to Active X List Box

Re: Editable Active X Textbox Linked to Active X List Box

Thread Information

Users Browsing this Thread

Similar Threads

Copy and paste an active cell in an active worksheet to a merged cells in another workshee

[SOLVED] Add Text in Active TextBox

[SOLVED] script to set linked cell on active x checkbox

Value of Active TextBox in a UserForm

Unable to send user-editable text to Outlook email body based on active cell.

Generate list box on active cell selection then place selections from box in active cell

Active X combo boxes turn blank or have values in them when I activate active x controls

Bookmarks

Bookmarks

Posting Permissions