Cells formatting done without me allowing it in VBA

  • Thread starter Thread starter Werner
  • Start date Start date
W

Werner

Hi,
I have 2 sheets that are used as source data. And I have a form where I
import from the source sheets data. After modifications, I copy back the
data in the source sheets. The problem is that cells formatted as
monetary values with decimal seem to copy as text. So when I try to do
automated mathematic functions in vba, it says incompatible type. And
when I debug in VBA, I see that the monetary values have quotation
marks in the yellow debug mode as if it was quoted as text. Is there a
way to prevent this side effect?
Thx!

Werner
 
Thx for the help Tom. Finally I have found a way to solve my problem
Before importing data from the source sheet I run a macro that format
all currency values into standard values. They, by this way, becom
regular numbers. It then copies those values into my form and they ar
reconverted as currency values after that. And my math functions wor
after that
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA help: Text file formatting 19
Converting String numbers into real numbers 2
Converting String numbers into real numbers 1
Copy value from changing cells without VBA 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Conditional Formatting and VBA 4
Apply cell formatting using VBA 1
Date formatting in VBA 1

Back
Top