Entering numeric values

[M atthew J. Couture]

I need some assistance, I have a workbook which will be used for user
entries, these entries are numeric values picked by the user. I am fairly
new to VBA and need advice on how to do the following:

User inputs numeric value into input box and clicks continue

I need the numeric value entered into the next empty cell in a colum and
then by clicking the continue button it initializes another user form which
has the same principles. This needs to be done with eight diffeent user
forms.

Any advice would be helpful

 

[Bob Phillips]

Not sure how the 8 are differentiated, but to get the next free cell, use
something like

Set NextFree = Cells(Rows.Count,"A").End(xlUp).Offset(1,0)
NextFree.Value = myValue

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)