0

I am working on an Excel spreadsheet that was created by someone else. The file contains a UserForm and on that UserForm there is a text field and also a CommandButton1.

enter image description here

As you can see the CommandButton1 is hidden on the UserForm. As far as I could evaluate the hiding of the the CommandButton1 is probably done by setting the top, left, height and width property to 0.

My question is now how can I get the properties of this CommandButton1 so I can change them back and make the button unhidden again. Is there a setting of the vba developing window I need to change so it displays me all the tools that are used in the UserForm?

Currently, my developing window looks like this:

enter image description here

Improve this question
2
  • Right click on the userform and click to properties or click to F4 ;) Commented Jun 29, 2018 at 7:12
  • You can list the controls' properties - cf. (How to find lost userform control)[stackoverflow.com/questions/50862861/… Commented Jun 29, 2018 at 8:47

1 Answer 1

Reset to default
2

Select the element you would like to modify on the dropdown (all elements of your form should be visible there):

enter image description here

If you cannot locate Properties window then go to View/Properties:

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Hi Pawel, I cannot find the dropdown in my developer window (see edits on my question). How can I add this window?
Go to View/Properties Window. I have edited answer with additional print screen.
Perfect. Thanks a lot.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.