Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Decimal point

Status
Not open for further replies.
DUF

DUF

Technical User
Mar 10, 2001
107
0
0
IE
Hi,
Does anyone knowe of a code that will allow the user to enter a cash value in a textbox without having to use a decimal piont, I want to automatically insert the Decimal point???

Can you point me in the right direction

Regards

Duf
 
Sort by date Sort by votes
Something like this ?
If IsNumeric(Textbox1.Value) Then
myCashValue = CCur(Textbox1.Value) / 100
End If

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Lavenderchan
  • Locked
  • Question
Plot Point Multiple (lat and long) with google maps
Replies
0
Views
22
Lavenderchan
Lavenderchan
patriciaxxx
  • Locked
  • Question
Using Dllregisterserver Entry Point in function with success failure returned 1
Replies
6
Views
64
patriciaxxx
patriciaxxx
fedum
  • Locked
  • Question
update a table with a decimal value from a textbox in a form with vba
Replies
18
Views
49
MajP
MajP
Rich8541
  • Locked
  • Question
function call starting point 3
Replies
6
Views
12
TheAceMan1
TheAceMan1
NWildblood
  • Locked
  • Question
VBA to set 4 decimal places
Replies
3
Views
13
NWildblood
NWildblood

Part and Inventory Search

Sponsor

Back
Top