Adding TextBox Value Next to Existing Item in ListBox

Hey all.

I am probably going about this the completely wrong way, but I set a form up in a specific manner, and now I am trying to figure out a way to make this work. I will try to explain the process as clearly as I can. Maybe it won't seem so complicated once I type it out.

I have a UserForm that contains a ListBox (ListBox1). Here is the code for this box:

With ListBox1

.AddItem "Option 1"
.AddItem "Option 2"
.AddItem "Option 3"
.AddItem "Option 4"

End With

I have a TextBox (TextBox1) that shows a date.

Is there a way to have the text in TextBox1 appear next to select items in the ListBox. I realize that the code I am about to show you doesn't work, but perhaps it will illustrate my point:

With ListBox1

.AddItem "Option 1" & TextBox1.Text
.AddItem "Option 2"
.AddItem "Option 3" & TextBox1.Text
.AddItem "Option 4"

End With

Any suggestions/ solutions would be greatly appreciated.

Thanks!

The code appears to work for me. I invoked it as follows

Private Sub UserForm_Activate()
With ListBox1

.AddItem "Option 1" & TextBox1.Text
.AddItem "Option 2"
.AddItem "Option 3" & TextBox1.Text
.AddItem "Option 4"

End With
End Sub

Please see the attachment

I forgot to mention that the TextBox starts blank and that it will change based on user input.

The location of the ListBox is within a tab. Should I place the code under the Sub for a tab change so that it refreshes?

Is there something special that needs to be done to make that happen?

Originally Posted by AliGW

It woudl be easier to help if you provided a sample workbook.

It is exactly what mrice had created except the textbox starts blank.

I have gotten the code to work when I populate the ListBox after the date has been entered, but I want to be able to replace the ListBox's contents should there be a change to this date.

Alright. So I found a working solution.

I have added the code so that any time there is a change in page it will clear the listbox and repopulate it based on the new information.

This keeps it up to date every time a user switches screens.

Thanks for letting me bounce ideas off you folks!