Number in cell formated as text

Hi,

I´m using a userform to transfer data to sheet 1 in my workbook.
In row 8 it´s transfers a number, but I get a warning that says the cell is formated as text.

I can change this manuell bu converting from text to number, but I need it to register the data as it surpose to be.

This is the code I use to transfer the data.

Please Login or Register  to view this content.

Regards
Øystein Breivik

TMShucks,

Thanks for youre reply, but that returns the error "Type mismatch"

Regards
Øystein

Hello,

Bump..... Anybody?

Regards
Øystein

try

Please Login or Register  to view this content.

nilem,

Thanks for youre reply, The second solution you gave me solved the problem

I have tryed to study several codes that I have been provided, but I cant figure out how it works.

What does exsample Dim, As Integer or As Double mean, and when are they suppose to be used?

Regards
Øystein Breivik

Hi, Øystein . You can read about declaring variables in the Help for VBA or, for example, here.

@Oeysbrei

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself.
Thanks.

nilem,

Thanks for the tip
A lot of god reading there, so hopefully it will be some quiet days at work that I can use for privat study

Regards
Øystein Breivik

---------- Post added at 08:30 PM ---------- Previous post was at 08:24 PM ----------

Cutter,

I always mark my threads as solved, but maybe I was a little slow this time.
I will keep that in mind next time

Regards
Øystein Breivik

Hi,

I thought I had this working as I wanted, but I sholdent be that lucky.
I have attached the workbook and a PDF file that explanes how it work.

Any help is much appreciated

Best regards

Øystein BreivikArbeidslogg Rev.1.xlsmDok1.pdf

for Registrering form

Please Login or Register  to view this content.

for UserForm1

Please Login or Register  to view this content.

nilem,

Thank you, now I will finaly mark this one as solved

Regards
Øystein Breivik