Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
Hello folks,
I am a complete novice regarding VBA so your help and advice will be much appreciated.
I have a 69 page Workbook into which I record individual players' performances and match records. Currently, I enter match details on each individual's page but I wondered if a UserForm might not be a better way to go. Some of the design facts are:
Player's names are listed on Sheet 9 in range B5:B64.
Fixtures are listed on sheet 1 in range A4:A31 (two lines per fixture - so effectively A4, A6 A8 etc.).
Match inputs go into (for match 1) B4, C4, D, E, J, L, M, N, O, Q, R, S, T, AC, AD, AD, AE, AF, AJ, AK, AL, AM, AN, AO, AP, AR and also in the cells and row beneath i.e. B5, C5 etc.
Depending on the name selected within the form (from a dropdown list?) the player's worksheets are sheets 10 to 69.
I really wouldn't know where to start with this project so your help will be very much appreciated.
Many thanks.
Mel
I am a complete novice regarding VBA so your help and advice will be much appreciated.
I have a 69 page Workbook into which I record individual players' performances and match records. Currently, I enter match details on each individual's page but I wondered if a UserForm might not be a better way to go. Some of the design facts are:
Player's names are listed on Sheet 9 in range B5:B64.
Fixtures are listed on sheet 1 in range A4:A31 (two lines per fixture - so effectively A4, A6 A8 etc.).
Match inputs go into (for match 1) B4, C4, D, E, J, L, M, N, O, Q, R, S, T, AC, AD, AD, AE, AF, AJ, AK, AL, AM, AN, AO, AP, AR and also in the cells and row beneath i.e. B5, C5 etc.
Depending on the name selected within the form (from a dropdown list?) the player's worksheets are sheets 10 to 69.
I really wouldn't know where to start with this project so your help will be very much appreciated.
Many thanks.
Mel