I have a vba code that works perfectly and allows a userform to appear when the window opens :

I have a userform (form_Updaterow), putting together some scripts to show additional info in a label when a textbox is clicked on.

and thank you in advance for your time,
I have been working on a userform (form_Updaterow), putting together some scripts to show additional info in a label when a textbox is clicked on. After much tinkering (I’m new to VBA, so I was not always sure of what I was doing) I finally managed to make it work. At least, it works fine when I F5-run the userform. However, when I open the form using .Show (either from another form or straight from a Macro), the script does not work. Could running and showing make something different?

Closed 12 mins ago.

Closed 12 mins ago.

Closed 12 mins ago.

Closed 12 mins ago.

I currently have a UserForm set up in an excel spreadsheet with multiple textboxes for inputting relevant data. One of these textboxes is used to input the date, I have set this up so you manually type in the date in the format dd/mm/yyyy however I have noted when I click the button and input all this data excel is automatically switching it so the numbers I put in for day and month get switched. So I input as dd/mm/yyyy and the way it is reading is mm/dd/yyyy.

I have created a very basic userform for entering data into my excel document, the document will be used to track figures from two buildings. I want to be able to input any data I have in my form and then when I click Ok it sends that data on the left to the sheet for Building 1 and the data on the right to the sheet for Building two. A bonus would be a pop-up form allowing me to select either building and this then bringing up a secondary userform with the relevant data to input. The data for these two buildings will be different and it will need different details so I cannot combine and send to both at the same time.

I’m working on a mini-calendar that is poping up when I click on a date in excel. The mini-calendar is made of userform. When I click on a date in the calendar, it transcribes it in the cell. Everything works fine. However, I would like to be able to click on the little arrows in the calendar to change the months and the years.