Batteredburrito
New Member
- Joined
- Jul 31, 2018
- Messages
- 15
Hi, I have a bit of an odd issue. Ive got a button that is going to open a MsgBox or InputBox and allow the user to enter in information. This information is there stored in a sheet called "Essential Info" and will store to cells "I2:I13"
What i am looking to do is display the input question
Within the inputbox.
This will loop round until one of two things occur; The user closes the input box or The input hits Cell 13.
At this point the MsgBox "Maximum account names reached" will appear and close the inputbox.
Im struggling currently with the loop function and identifying when the maximum account cells have been reached.
Would anyone have any ideas?
What i am looking to do is display the input question
Code:
"Please enter account name: " & vbNewLine & "Click Close once you are done"Within the inputbox.
This will loop round until one of two things occur; The user closes the input box or The input hits Cell 13.
At this point the MsgBox "Maximum account names reached" will appear and close the inputbox.
Im struggling currently with the loop function and identifying when the maximum account cells have been reached.
Would anyone have any ideas?
