UserForm Result Posting

[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-


..

 

[Bill Manville]

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

Could it be a multi-select list box?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup

 

[Randal W. Hozeski]

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-

..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!