UserForm Result Posting

  • Thread starter Thread starter Randal W. Hozeski
  • Start date Start date
R

Randal W. Hozeski

I am using the following code to display results of a userform,
but for some reason the ListBox2 does not populate my sheet.
ListBox1 and TextBox1 come thru fine. ListBox2 to is a date
field. Any idea why/suggestions?

NextRow = _
Application.WorksheetFunction.CountA(Range("A:A")) + 1
Cells(NextRow, 1) = ListBox1.Text
Cells(NextRow, 2) = ListBox2.Text (tried .Value too)
Cells(NextRow, 3) = TextBox1.Text

Thanks -Randy-


..
 
Randal said:
I am using the following code to display results of a userform,
but for some reason the ListBox2 does not populate my sheet.
Click to expand...

Could it be a multi-select list box?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
It was because of the formula result that populated the ListBox2. We
had to turn ReCal mode to manually, run it then turn it back to auto.
Then it worked fine. It was a single select ListBox. -Randy-

..
 
Back
Top