Copying data from a form to a cell

**CarlosVA** · 06-12-2013, 05:28 PM

Hi this is my first post

Right now i have a vba that copies the data in the fields of a form and saves them on another sheet in a specific order.

My issue is that there are some field that need to be saved as numbers but they apear to be text untill I double click on them and then they turn in to numbers.

Im using excel 2007, bellow the code im using:

Please Login or Register  to view this content.

Thanks for any help you can provide

**JBeaucaire** · 06-12-2013, 06:47 PM

If you know a text value is really a number, if you add zero to that text value, it becomes a real number.

So, in your example, for instance, if NOMBRECIA is a value that IS a number but is being entered as text, two solutions I can suggest:

1) Format that column as a specific number format first and perhaps the entries will be correct when VBA-entered later
2) Use a +0 after the NOMBRECIA

Please Login or Register  to view this content.

**CarlosVA** · 06-13-2013, 11:06 AM

Thank you JB,

That worked like a charm, also adding .value after the fiel (NOMBRECIA.VALUE) worked in the same way.

Is it ok to ask another Q regarding the same code in here or do I have to create another post?.

Example: it is the same project, same form, but now its about number format in the form field.

Thanks again

CV

**JBeaucaire** · 06-13-2013, 11:48 AM

Its best not to treat a single thread as a "project" thread because other people seldom look at "actively answered threads", most new eyes are drawn to threads with zero or only a couple replies. Also, if you post only here, you'll be waiting on me.

Each separate query in a separate thread means new eyes possibly responding quicker. If a helper stumps your thread without a working solution, ping a Moderator to take a look.

If you do not get a response to a particular thread, resist the urge to "bump" it, that also takes it off the "Unanswered Threads" list above in the dark blue menu bar, you don't want to do that prematurely. If 24 hrs goes by with no responses, you can tug my sleeve with a Private Message and link to the thread.

Some other contributors here view that as a violation of the rule #4 and don't like it, so tread carefully tugging other sleeves.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.