First empty cell

[Guest]

I have what I hope to be a simple question. 2 parts - I have a userform with
a textbox and a button , when the user hits commandbutton 1 I would like the
text they've written to automaticaly goto the first emty cell in sheet
'Tasks' Column B. Then automaticaly close that userform and launch userform
'choose date'. I was just going to unload form, and show.choosedate. Is
that correct?

Thank you to anyone that helps.

 

[matt]

I have what I hope to be a simple question. 2 parts - I have a userform with
a textbox and a button , when the user hits commandbutton 1 I would like the
text they've written to automaticaly goto the first emty cell in sheet
'Tasks' Column B. Then automaticaly close that userform and launch userform
'choose date'. I was just going to unload form, and show.choosedate. Is
that correct?

Thank you to anyone that helps.

On the click event for commandbutton1, use the hierarchy notation to
get the information to the spreadsheet. For example, in the click
event you could code something like the following:

Dim counter

counter = Range("B1").CurrentRegion.Rows.Count

Range("B" & counter + 1).Value = userForm1.TextBox.Value

userForm1.Hide
userForm2.Show

'code for userForm2
'and use Unload userForm# to clear it from system memory

Matt