jagdipa

Is there a tab string character?
i.e. I want something like

"date: " & TAB & "3/3/23" & vbNewLine & _
"time: " & TAB & "4:34"

Jagdip

Peperl

I think TAB Ascii code is the number nine. Try to declare it as a constant


and try

John

The better way is to use the built in constant vbTab.

These can be found by looking in the object browser or by typing keycodeconstants followed by a "." which will bring up the whole list.

Dave124

a good way to see what keys what in ascii is to use msgbox.

for example

msgbox (vbkeyspace)

this would display 32 in the msgbox which is the ascii for it.

another example

msgbox (vbkeyup)

this would dsiplay 38 in the msgbox.

using msgbox is a good way of getting tons of info thing's.

experiment!

John

Not as good as the immediate window would be.

Ctrl+G
Print asc(vbkeytab)
57