Good afternoon all.
Thank you very much Sam and Asa. Actually I am not so sound in code
building. I am working in a office and trying to minimise and simplifying
my dealing work by automating the data entry. For that I joined for VB 6.0
and built some programs but many were failed. After a lon
WorksheetFunction.Text(1,"") = 0001
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shankar Bheema
Sent: Jan/Mon/2012 11:32
To: excel-macros@googlegroups.com; Sam Mathai Chacko
Subject: $$Excel-Macros$$ prefix 0 problem
Dear Experts
In the
Thank you asa.
On Mon, Jan 30, 2012 at 1:40 PM, Asa Rossoff wrote:
> Hello Shankar,
>
> You can use Format() in VBA.
>
> txttotser.Text = Format(txttotyrs.Value, "00") & Format(txttotmths.Value,
> "00") & Format(txttotdays.Value, "00")
>
> ** **
>
> To use Application.Worksheetfuncti
Hello Shankar,
You can use Format() in VBA.
txttotser.Text = Format(txttotyrs.Value, "00") & Format(txttotmths.Value,
"00") & Format(txttotdays.Value, "00")
To use Application.Worksheetfunction.Text, it would go like:
txttotser.Text = Application.WorksheetFunction.Text(txttotyrs.Value, "00")
