$ symbol

C

Chas17

Well-known Member
Joined
Oct 16, 2002
Messages
657
In the one line code:

UserForm1.lblClock.Caption = Format$(Time, "hh:mm:ss AM/PM")

What does the $ sign do after the Format ?

Chas
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
N

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
In VBA, though usually in the DIM statement, it is a shortcut for declaring a string variable.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
timestamp now() vs live clock
Replies
2
Views
304
palaeontology
P
R
  • Solved
VBA in Excel to find free appointment in Outlook and display in an email
Replies
8
Views
621
RockEd
R
P
  • Question
Live Clock in a single cell
Replies
1
Views
199
DanteAmor
DanteAmor
K
  • Question
Using macro to sign and lock spreadsheet - but failed!
Replies
2
Views
124
Koala123
K
H
  • Question
Searching for text and making modification
Replies
0
Views
267
HotLanta
H

Forum statistics

Threads
1,195,671
Messages
6,011,077
Members
441,581
Latest member
rp4717

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top