Help, No Userform running errors, but no Cbox values added to sheet on cmd button press

[taffboyo]

Hi Everyone,

i am using the below code to place numbers into a grid on a worksheet, the numbers are selected from a userform full of combo boxes. The userform itself is running ok, with regard to no errors during use, but upon pressing the cmd button nothing is being pasted onto the sheet. can someone have a quick look at the code below and see if i am missing something obvious, ive not had any issues with the below code in the past, thanks.

code:

Please Login or Register  to view this content.

[AlphaFrog]

You declare rRef and cNum in the Addme procedure. Those variables are local to that procedure. Local variables cannot be set in the CommandButton1_Click procedure, and subsequently passed to the Addme procedure like that.