Format & ControlSource

[Guest]

I want a TextBox with ControlSource use the same Number-Format as the
ControlSource-cell.

Is my perception correct that there is no easy way to do this (but to write
a textbox_change procedure)?

Oskar von dem Hagen

P.S. Excel 2K, W2K SP4

 

[Bob Phillips]

This is a problem Oskar.

I tend to remove ControlSource in these cases and use the Enter event to
format it., like so

Private Sub TextBox1_Enter()
TextBox1.Text = Format(TextBox1.Text, "dd-mmm")
End Sub