Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
What I require is the macro code (which I will be running from a button) that will pop up a message box asking the user for the password (which will be hidden in A1), after verifying the password is valid the user will be then prompted for the following information:-
<o></o>
(a) cell reference e.g. F1, G9, AB56 etc etc
(b) data to be input in cell range defined e.g. test data etc etc
<o></o>
When the user is happy with their choices and presses the OK button the data will be entered in to the cell selected.
<o></o>
<o></o>
Any help would be greatly appreciated
<o></o>
<o></o>
Many thanks in advance
<o></o>
<o></o>
Rob
<o></o>
N.B. Excel version 2003
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
What I require is the macro code (which I will be running from a button) that will pop up a message box asking the user for the password (which will be hidden in A1), after verifying the password is valid the user will be then prompted for the following information:-
<o></o>
(a) cell reference e.g. F1, G9, AB56 etc etc
(b) data to be input in cell range defined e.g. test data etc etc
<o></o>
When the user is happy with their choices and presses the OK button the data will be entered in to the cell selected.
<o></o>
<o></o>
Any help would be greatly appreciated
<o></o>
<o></o>
Many thanks in advance
<o></o>
<o></o>
Rob
<o></o>
N.B. Excel version 2003