I have been trying to create a macro so when played, it will open
form. This however doesnt work. Is there a way of doing this?

--
Message posted from http://www.ExcelForum.com

Depends on what you mean by form. If you mean userform:

Sub showForm()
userform1.show
End Sub

--
Regards,
Tom Ogilvy

jamie85 wrote in message
...
I have been trying to create a macro so when played, it will open a
form. This however doesnt work. Is there a way of doing this??


---
Message posted from http://www.ExcelForum.com/

Ok i have created a form and the user can enter two peices of data
'Item No.' and 'No. of items'. After the user has entered these it ask
if you would like to enter another record. When i click yes and ente
another record it enters the information in the same place as th
previous record i entered. I want it to move down a row everytime
enter a new record. Is there any code available for this? THank

--
Message posted from http://www.ExcelForum.com

Assume your Item no data is in column 1 of sheet1

Dim rng as Range
set rng = Worksheets("sheet1").Cells(rows.count,1).end(xlup) (2)
rng.Value = Textbox1.Text
rng.offset(0,1).Value = Textbox2.Text

--
Regards,
Tom Ogilvy

jamie85 wrote in message
...
Ok i have created a form and the user can enter two peices of data,
'Item No.' and 'No. of items'. After the user has entered these it asks
if you would like to enter another record. When i click yes and enter
another record it enters the information in the same place as the
previous record i entered. I want it to move down a row everytime i
enter a new record. Is there any code available for this? THanks


---
Message posted from http://www.ExcelForum.com/