Generating and returning a random number to a cell by clicking a Button

[aea1022]

Hi,

I am new to excel VBA and Macros. I am trying to create a click button to automatically generate a random number (1000,9999) to "F5" cell in my worksheet. I have created the form Button used record macros to record the steps using the RAND(1000,9999) function typed into F5 after I click the button.

This is the code I am running:

Please Login or Register  to view this content.

When I click the button I am getting VBA compile error: "invalid outside procedure". I read that this error is to do with declaring variables but I am not sure if this is the case here.
Any help is appreciated. Thanks.

[nankw83]

Hi aea1022 & welcome to the forum

Try below code ...

Please Login or Register  to view this content.

[aea1022]

Thanks nankw83,

Your solution works perfectly.

[nankw83]

Glad to help & thanks for the added Rep+

Please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post