VBA

[jj98]

Need help so I need my inputbox to appear right when I open excel. I did subworkbook_open() however that did not work. I need to know how to appear an inoutbox that says enter your name and when I enter my name it displays in A21 saying updated by "name" and after that another inputbox to appear saying enter whole number and when entered displays in B1. I did dims, set, and referenced input box= but it did not work anyone know?

 

[mrshl9898]

Did you put this in the "This Workbook" module?

Private Sub Workbook_Open()

' Put your code here

End Sub