View Full Version : Radio button, activate, highlight cells?
doctortt
04-30-2011, 04:48 PM
Is it possible to do this?
If a user select this radio button on the excel sheet, Excel will automatically change the color of the cells?
Then if a user de-select this radio button, the color of these cells disappear?
mikerickson
04-30-2011, 05:05 PM
It could be done with VBA, but a non-VB approach would be to link the option button(s) to a cell ($E$11 in this example) and then have Conditional Formatting on the row in question with formulas like =($E$11=1) to determine which color it should be.
doctortt
04-30-2011, 05:21 PM
It could be done with VBA, but a non-VB approach would be to link the option button(s) to a cell ($E$11 in this example) and then have Conditional Formatting on the row in question with formulas like =($E$11=1) to determine which color it should be.
Thanks a lot
doctortt
04-30-2011, 05:22 PM
Hi
Is it possible to have a user to click a button on the Excel sheet and Excel will automatically play an EMBEDDED wav file (without opening windos media player?)
Thanks
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.