MACRO QUESTION

[duderdog]

I'm attempting to create a macro that will execute and then pause for input from the user and then continue. I'm clueless. I'm an old Lotus user where you could put a question in the middle and it would do that...Can anyone help me? Specifically what I want the macro to do is to unprotect the worksheet change the font on the active cell - accept new data - and then reprotect the worksheet.

 

[elgringo56]

Use an InputBox as follows:

Range("BP1") = InputBox("This is what you want the user to input.")

The macro will stop until the user inputs something and that something will be in BP1 or whatever cell you choose.

 

[duderdog]

Thanks for your response but what if it's not an absolute cell but I need it for any active cell --- would it be ActiveCell=InputBox?

 

[elgringo56]

Yes, that does seem to work.

 

[duderdog]

Thank you - don't mean to be a bother - but does it make a difference if the data to be input is of different types. I.e. some are letters and some are numbers