Macros and IF Functions

  • Thread starter Thread starter Keri
  • Start date Start date
K

Keri

Hello,

Can anyone tell me if I can use a Macro check box as
logical text in an IF function? For instance if the box
is checked A1 should display "Blue". If I can't use
Macros in an IF statement, is there another way to get the
same results? Thanks,

--Keri
 
Keri,

You could use the checkbox from the forms commandbar, and link it to a
cell - right click on the checkbox, select "Format Control...", then click
on the Control tab, and select a cell for the cell link. For example, use
cell A2, formatted for custom ";;;" (which is hidden). Then in A1, you can
use the formula

=IF(A2,"Blue","")

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros and IF Functions 1
populate cells using select case 3
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
How to write Left Function in VB 2
Need Macro... 8
How check if Application.Run fails?? 2
CONCATENATE IF macro or function? 3

Back
Top