![]() |
IF Function Question
Hi,
I am using a worksheet with Checkboxes included. I need to create a function that if the checkbox is checked, a value will show in another cell. I can't figure out how to make the logical test relate to the control/form checkbox. Is it possible to do this? Or do I need to create a macro in VB to do this? Any ideas? Thanks, Carl |
IF Function Question
In design mode, right-click your checkbox and select Properties. You should
have an option for 'LinkedCell'. Set the cell that you would like the checkbox linked to. HTH, Paul -- wrote in message ... Hi, I am using a worksheet with Checkboxes included. I need to create a function that if the checkbox is checked, a value will show in another cell. I can't figure out how to make the logical test relate to the control/form checkbox. Is it possible to do this? Or do I need to create a macro in VB to do this? Any ideas? Thanks, Carl |
All times are GMT +1. The time now is 01:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com