text in listbox
Hello,
When using a listbox in a userform, I can insert a number into the worksheet indicating the position of the item I selected, however, I wanted to insert the actual text. I was reading about the .list & .listindex options, but I am not having much luck. I am using Excel 2000. What is the code that would insert the actual text from the userform into the worksheet. My text is in this form "May 03". thanks in advance Bill |
text in listbox
Bill,
Try something like With UserForm1.ListBox1 If .ListIndex = 0 Then Range("A1").Value = .List(.ListIndex) End If End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bill" wrote in message ... Hello, When using a listbox in a userform, I can insert a number into the worksheet indicating the position of the item I selected, however, I wanted to insert the actual text. I was reading about the .list & .listindex options, but I am not having much luck. I am using Excel 2000. What is the code that would insert the actual text from the userform into the worksheet. My text is in this form "May 03". thanks in advance Bill |
All times are GMT +1. The time now is 01:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com