Return currency value from textbox to an excel cell 
Author Message
 Return currency value from textbox to an excel cell


I'm going out of my mind with this.
I have a textbox (PRE?O_COMPRA) in an userform connected to a cell.
When I call the userform, the textbox gets the value from the cell
(currency value)

UserForm11.PRE?O_COMPRA.Value = Sheets("LISTA DO
STOCK").Cells(LASTROW, 16)
'more stuff
End sub

Private Sub PRE?O_COMPRA_Change()
PRE?O_COMPRA = FormatCurrency(PRE?O_COMPRA, 2)
End Sub

I have format the cells(lastrow,16) as currency.
 This works okay!

The problem is that when I want to place the value from the textbox to
the cell I will get a string instead of a currency value. My cell gets
like this: 8.741,39 € and it should be 8741,39. More strangely, if I
double click on the cell and do enter the value becomes a currency
value, just like that!!!

Can anyone help me, please?!!?!?!

Sun, 27 Nov 2005 16:38:56 GMT  
 [ 1 post ] 

 Relevant Pages 

1. How To put The textbox value in the cell of Excel

2. Excel VBA function -- grabs a value from an MS cube and returns it to a cell

3. Syntax for returning cell value to UserForm in Excel 97

4. Excel 97: Mix formula return value and text string in a cell without =concatenate()

5. Retrieving highlighted cells from Excel and return values to VB aplication

6. Currency field query that returns currency format?

7. Print PDF in Excel X, Search a specific value in cells/Replace value in other cells

8. Returning Cell References where Cell Values are the same

9. VLOOKUP cell address not cell value returned.

10. Textbox values based on other textbox values

Powered by phpBB® Forum Software © phpBB Group