• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditionally display CMD button based on cell value

R

Rodger

Member
I have been trying for some time to figure this out, but alas ...

I have a column, say A1:A20, only some may be populated, but more could be later.
Is it possible to have a Form Control button appear beside the ones that have text?
The programming for all the potential buttons is done, but currently they are sitting beside empty cells, I would like them to appear only when the cell beside it has text.

I know there is a way, and prefer to teach myself rather than ask, so thanks if anyone knows the trick.

Rodger
 
Hi ,

You can use the Workbook_Open and the Worksheet_Change event procedures to hide / display the buttons which have text in the cells beside them.

If you want members to code this for you , please upload your workbook with the buttons in them.

Narayan
 
That is the idea.
Hoping for a code to make the un-needed buttons invisible, until the cell next to it is populated.

thanks all
 

Attachments

  • Sales Analysis.xlsx
    11.8 KB · Views: 1
You must log in or register to reply here.
Back
Top