Search results
16 gru 2014 · The idea is click the button, bring up the userform, enter info, hit OK, and your info is formatted correctly and inserted into the worksheet. I have 3 userforms that all work fine, but any macro I create that references one of them just does not recognize that that particular userform exists.
27 maj 2010 · IF I add a user form, I can change default form name from UserForm1 to whatever I'd like; lets say I rename it to u1. Lets say I create a userform click event that states: MsgBox Me.Name. That will work and msgbox will return 'u1'.
14 kwi 2020 · This code opens up a UserForm in the middle of the application everytime. If this doesn't work, then you either have the code in the wrong location or the UserForm is named something different. This code should not be in any Worksheet modules.
6 kwi 2018 · Here's my issue; When I select 'OK' in the MsgBox the MsgBox disappears normally but code continues to add the data to the respective locations without the employee's name. I need a piece of code to halt the 'Add To Sheet' process or disable the button until Reg2 is populated.
8 cze 2024 · You can modify the Caption on the Userform without activating "Trusted access to object model of VBA project". Modifying the Caption does not rename the Userform but the Caption is what the user sees and there is no reason for the User to know the code name for the Userform.
27 lip 2010 · It won't let you rename the TextBox to txtName because the first Label control on the UserForm is named that... you cannot have two controls (even if they are different kinds of controls) with the same name. You might consider renaming your Label control lblName and then you will be able to name your TextBox to txtName if you want.
30 kwi 2016 · To change the name of the UserForm do the following. Click on the UserForm in the Project window or click on the UserForm itself. Click in the (Name) field of the Properties window. Enter the new name in this field.
