Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA .activate
Hi,
I am needing some help with a code, I have 150 sheets in a workbook in relation to stock items, I have 4 columns of date I need to enter into these sheets. e.g. Date Stock +/- Stock Total Initials These are the 4 headings of the columns, what I am looking to do is that I fill in Date and Stock +/- after that I want to put in initials of person removing stock e.g KJ then after I have input the initials and hit enter I want to activate so that after initials are input it will automatically return to sheet1 "Index of Stock" Can anyone help me on this code? Many thanks Terilad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reliably activate PowerPoint, do something, Activate Excel | Excel Programming | |||
activate VBA | Excel Programming | |||
activate VBA | Excel Programming | |||
Windows().Activate vs Workbooks().Activate | Excel Programming | |||
Workbook.Activate / Window.Activate problem | Excel Programming |