incrementing field number

[mona4]

Hi,

Is there a way that every time you open a spreadsheet the field number on the sheet increments a bit like a counter?

Thanks
Mona

 

[Richard Schollar]

OK, depending on what name your textbox has (quite possibly will be TextBox1) and the name of the relevant spreadsheet(s), then the code specifics you'll be looking for will be something like:

Private Sub Workbook_Open()
With Sheets("Sheet1").Range("A1")
    .Value = .Value + 1
    Sheets("sheet1").TextBox1.Value = .Value
End With
End Sub

Richard

 

[mona4]

thank you very much, just what i needed.