Re: Insert Functions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 22:29:09 +0100

Hi
in VBA why not use something like
activecell.value = now 

-- 
Regards
Frank Kabel
Frankfurt, Germany
"reset" <reset@portsphere.com> schrieb im Newsbeitrag 
news:vsHxd.6$4h.0@okepread03...
> Hello,
>
> I need to insert the current time and date into excel when a barcode is 
> scanned from an ID card. It requires the [ "ctrl" + "shift" + ";"  ] for 
> which I can't find an ansii code for the latter or how to input the 
> combination.. Any ideas how I can put this into the code so it will output 
> to excel when the card is scanned. Also, it would be nice at the end of 
> the code to get the focus to go to the next row, first column after a 
> scan, to be ready for the next card. Any help is greatly appreciated.
>
> David A. Powell
>

Relevant Pages