conditional formatting

[ryan_law2000]

Ok so i have a userform that pastes informtaion into specific cells.

Userform code:
ActiveCell.Offset(0, 25) = DimensionData.TextBox25

That cell is Z4 on the worksheet
conditional formating:
cell =$Z4>1 then turn =$B$4:$AA$1000 Green.

Then problem is even when NO information is entered in the userform all the cells turn green (as if its entering a phantom number)

If I go to Z4 (blank cell at this point) and press delete then cells turn back to normal fill

How can I make this NOT paste a phantom number so the conditional formatting will work properly

Thanks

 

[ryan_law2000]

I guess what Im thinking is in the userform

ActiveCell.Offset(0, 25) = DimensionData.TextBox25

But somehow add

If Textbox25 is blank then do not paste info


some kinda code like that might work?

 

[VoG]

Perhaps

If DimensionData.TextBox25.Text <> "" Then ActiveCell.Offset(0, 25) = DimensionData.TextBox25.Text

 

[ryan_law2000]

Works Perfect!
Thanks!