label -> cell display

[Av8tordude]

How can I get a form label caption to display in two different cells?

Example

$1.09: A1 = 1 & B1 = .09

or

$23.38: A2 = 23 & B2 = .38

or

$287.00: A3 = 287 & B3= 00

 

[shg]

If this is an ActiveX label on a worksheet,

    With Sheet1.Label1
        .Caption = "12.34"
        Range("A1").Value = Int(.Caption)
        Range("B1").Value = .Caption - Int(.Caption)
    End With

 

[Av8tordude]

Actually the label is on a form, but can I assume this will work as well?

 

[shg]

No need to assume, try it .