Entering $ sign into a calculation on a user form

**Nole68** · 01-20-2016, 05:54 PM

I am doing some math in a user form and I want the result to be expressed in dollars with decimal and dollar sign. So the filed ExportValueLabel I want expressed this way.

Private Sub CommandButton4_Click()

'Calculating the export value, net weight and Gross weight
ExportValueLabel = CaseQuantityTextBox * CasePriceTextBox
NetWeightLabel = CaseQuantityTextBox * 30
GrossWeightLabel = CaseQuantityTextBox * 31.38

End Sub

**shg** · 01-20-2016, 05:58 PM

Please Login or Register  to view this content.

**Nole68** · 01-20-2016, 06:01 PM

Thanks shg, I knew it was simple, I am green but getting there!

**shg** · 01-20-2016, 07:03 PM

You're welcome.

Entering $ sign into a calculation on a user form

LinkBack

Thread Tools

Rate This Thread

Display

Entering $ sign into a calculation on a user form

Re: Entering $ sign into a calculation on a user form

Re: Entering $ sign into a calculation on a user form

Re: Entering $ sign into a calculation on a user form

Thread Information

Users Browsing this Thread

Similar Threads

Return to user form but dissapears upon entering a value thus failing to 'submit'

[SOLVED] Define where to start entering data from a user form

Entering image in to a worksheet from user form

How to write a VBA with User form for Entering the DATA to print a cheque

Custom Design Data Entry User Form for Entering Customer Information

Calling a user form initialize sub when entering the form to populate combobox...

Entering worksheet data via user form

Bookmarks

Bookmarks

Posting Permissions