Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I need a macro please that when I select a cell or range of cells and run the code an input box pops up and does the following.
If I enter a number and press enter it places a word or sentence into the cell(s).
1. Test
2. No data available
3. Test 3
And so on up to about 10. I can change in the code the words or sentences to suit.
Thanks.
If I enter a number and press enter it places a word or sentence into the cell(s).
1. Test
2. No data available
3. Test 3
And so on up to about 10. I can change in the code the words or sentences to suit.
Thanks.