HOW to change the color button based on changing any of the cells value
i want to change the color of the button on the user form based on changing any of the cells value in column E
SHEET2 , column E
For example
This is what I wrote
But it doesn't work
Please Login or Register to view this content.
Please help with this
Last edited by MOHAMED121212; 11-15-2020 at 10:56 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. You are new here, so I have done it for you today.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Welcome to the forum
Attach a copy of your workbook so that we are able to see the complete context that you wish to solve.
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I don't know how to attach my workbook
I have attached the code for the operation with an explanation of what I want
Rather than spend time with dozens of questions and answers using crystal ball gazing.
Help us to help you - there is a big yellow banner at the head of the page explaining how to upload your workbook.
With your workbook the answer would become obvious what you have done wrong and you will get a far speedier resolution.
torachan.
hey i have uploaded the file
I have placed code in the sheet module
I have difficulty envisaging a use for this action
the form must be present and active also show module = false to enable you to put values into column "E"
torachan.
Hi Mohamed
In the attached file, I simplified your request.
Does this help you??
If not, please ask again..
zeddy
I took too long drinking my tea, torachan was quicker!
zeddy
Excel Tactical Beverages Unit
Originally Posted by torachan
I have placed code in the sheet module
I have difficulty envisaging a use for this action
the form must be present and active also show module = false to enable you to put values into column "E"
torachan.
Torachan
Really, thank you very much for your help, but there is a slight modification that I want from you, please
I want to change the button color in the user form based on changing any of the cells in column E, and column f in the same row
I know that I ask a lot, but I made a mistake in my first request and did not write everything I wanted
Finally, thank you for your patience.
zeddy
Thank you for the nice simplification
but there is a slight modification that I want from you, please
I want to change the button color in the user form based on changing any of the cells in column E, and column f in the same row
Torachan wrote it in code without COUNTIF
I want it from you in the same way as you, in order to learn the two methods from you and from Torachan
Finally, thank you for your patience.
Hi Mohamed
OK, have a look at this updated attached version v1b.
The conditions I have chosen are:
column E has a value 1 entered somewhere, and the cell in column F, on the same row, has "cat" entered.
If both these conditions are met (anywhere within columns E and F), then your button colour is set as required.
NOTE: I only check for the FIRST value of 1 in column E, and its corresponding adjacent entry!
If there are multiple entries of 1 in column E, then the code would need adjusting, to check every 'pair' of values etc etc etc
zeddy
Last edited by zzzeddy; 11-15-2020 at 04:53 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks