Date and time by using the command button

[dinesh009]

Hi,

I am tring to get the start date and end date by command button but want this date and time to be given in particular coloum only not in active cell and this need to be continued in next rows by clicking command button

[Alf]

You could try something like this

Please Login or Register  to view this content.

Alf

[dinesh009]

This code is not working, pls help me on this

[Alf]

I've tested it and it worked for me so you need to explain it a bit better if you exspect me to be able to help you.
Alf

[dinesh009]

I have past this code in command button in vb editor but when I click on command button no date is showing

[Alf]

Try the command buttin in this file and see if it works.

Alf

[HaroonSid]

Hello Alf

if i need the date only in cell "A4"

plz rep

[Alf]

Just use this line in a macro

Please Login or Register  to view this content.

Alf

[HaroonSid]

PLZ Alf
i have little knowledge of vba
plz post full code

[Alf]

Please Login or Register  to view this content.

Forum rule #2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.

So I'll stop answering your qustions in this thread. If you got more questions start a thread of your own,

Alf

[HaroonSid]

thanx
for reply