Syntax for FormatCurrency

This is Excel VBA
I have this piece of code I need to add

FormatCurrency to this line in the code
(TextBox2.Text = rng(.ListIndex + 1, 3)

What would be the proper syntax?

Any help would greatly be appreciated

/////////////////////////////////////////////////////////
With ComboBox1
        Set rng = Range(.RowSource)
        TextBox1.Text = rng(.ListIndex + 1, 2)
       (TextBox2.Text = rng(.ListIndex + 1, 3)        
     End With
ca1358Asked:
Who is Participating?
 
gecko_au2003Connect With a Mentor Commented:
Dim curOne As Currency
Dim curTwo As Currency

For i = LBound(ComboBox1.Count) To UBound(ComboBox1.Count - 1)

With ComboBox1
        Set rng = Range(.RowSource)
        curOne = Format(rng(.ListIndex + 1, i) , Currency)       '< --- here
        curTwo = Format(rng(.ListIndex + 1, i), Currency)        '< ---- and here
TextBox1.Text = curOne
TextBox2.Text = curTwo
End With

Next

something like that maybe ? If not then just get rid of the for next loop and replace the i is above with the 2 and 3 you had originally

Hopefully this helps anyway ( With regards to the format function, here is a reference )

http://msdn2.microsoft.com/en-us/library/y006s0cz.aspx

If you need more help post back

0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In Excel VBA you can use CCur(value) to convert any value to a currency $#,###.## format.
0
 
ca1358Author Commented:
Sorry,  I should have told you it is a UserForm.

0
 
ca1358Author Commented:
Thank you!
0
 
gecko_au2003Commented:
np - hopefully it worked for you ( I was just wrote the code out from memory )
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.