Input Button Command Question

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

Hi all,
Is there a way to have an input button show a default value formatted in
date format. That is as d/m/yyyy. (I can get it to show the date but
insists on showing it in number format only)
 
Don't know what you mean by "Input Button".
Could try something like :-
mystring = Format(Date, "d/m/yyyy")
CommandButton1.Caption=mystring
 
Thanks Brian. Sorry about being unclear. The function is for an InputBox
NOT Input Button. Your solution seems to do the trick though by just using
Format(Date, "d/m/yyyy") as the default.
Rob
 
Back
Top