Issues with setting focus on Userform

Hi,

I have a userform that is called by clicking on a button and it copies the value in cell A to my userform. This works great it is called via:

Please Login or Register  to view this content.

However, when using this method for some reason another peice of code that I have on a userform that pops up from the first does not see 'FmNAS' as visible. I am using a calendar form and instead of updating the value on the userform it updates the active cell.

Is there a way the code above can set the focus on the userform rather than the active cell? The spreadsheet is very large so I cannot post an example.

Thank you in advance

That's not a question of focus, it's just that the code is wrong (are you using Selection?) It would be helpful to see the code on the calendar form that returns the value.

Hello jpruffle,

The code you have (shown below) creates a New Instance of the UserForm. That is not what you want to do. You need to set an Object Variable to the UserForm. The reason you can't show frm is because it has not been added to the UserForms collection.

Please Login or Register  to view this content.

Change your code to this...

Please Login or Register  to view this content.

Are you loading the calendar from fmNas? If so, what code are you using for that?