hi,

I'm looking for a way to make a text box on a form only visible on
certain days of the week. the code i have tried is below. its a bit
naive to be honest so any suggestions would be appreciated:

Private Sub UserForm_Initialize()

If Date = vbSaturday Then
LblIntMon.Caption = "Weight"
TxtBody.Visible = False

TxtBody.Text = LastWeight
Else
LblIntMon.Caption = ""
TxtBody.Visible = False
TxtBody.Text = LastWeight

End If

Thanks in advance


--
andywalker
------------------------------------------------------------------------
andywalker's Profile: http://www.excelforum.com/member.php...o&userid=24418
View this thread: http://www.excelforum.com/showthread...hreadid=382216