If with Checkbox, VBA

[tlindeman]

Is there a way in VBA to create a textbox if a cell has a value. So On Worksheet "Master Calendar" I would like to enter a value in cell A1 if cell A1 on "lifting calendar" has a value, other wise I would like the cell to be blank.

Thank you
Tony

 

[Tom Urtis]

If you want to enter a value in cell A1 of Master Calendar if there is a value in cell A1 of lifting calendar, where exactly does the textbox come into play?

And why would you need a textbox if you are only entering directly into cells, and where would it be placed if you do need it?

 

[tlindeman]

sorry I meant checkbox, not text box.

Thank You

 

[tlindeman]

Sorry, I was working on two things at once, so I would like a checkbox automatically created in cell A2 if Cell A1 has a value. If possible I would also like the checkbox to refer to cell A2, so if checkbox is checked, cell A2 would display TRUE, otherwise false.