UserForm Frame

Greetings,
I have been struggling trying to figure out why the following code is not working. The code is inside the UserForm_Initialize.
"fr_Chg_Mnth_2" is the Frame I am wanting to show/hide based on the following code. If cell DC4 on sheet8 contains text I want the Frame to show. If cell DC4 on sheet8 is empty I want the Frame to hide.

Please Login or Register  to view this content.

That code works fine for me.
Are you sure that you are looking at the correct cell on the correct sheet?
Also if you just want to hide a command button, why not just use the Visible property of the button, rather than put a frame over it?

Fluff13,
Thank you for the recommendation. I figured out what the problem was, I was using a "Me.Hide" when closing the Userform instead of "Unload..."
However, I am curious about using the "Visible property of the button.

You can use something like this to "hide" the commanButton

Please Login or Register  to view this content.

That is what I am using.
Works now.

You're welcome & thanks for the feedback

Originally Posted by Fluff13

You can use something like this to "hide" the commanButton

Please Login or Register  to view this content.

For those who might be interested, this can be compacted down to this single line of code...

Please Login or Register  to view this content.

Rick,
How would I make the CommandButton1 not Visible if DC4 has text. It shows now if the cell has text.

Rick,
Actually I have a few CommandButtons that are "backwards" in the code. However, your code works great!
Thank you much!