Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
First empty cell
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
First empty cell
On Mar 22, 1:53 pm, Benz wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Finding next empty empty cell in a range of columns | Excel Programming | |||
Empty cell and a the empty String | Excel Programming |