Values from Userform to Worksheet

[brentjohn]

Greetings,
I am using an Userform to enter values, that will need to be placed on a Worksheet. The Userform contains 2 textboxes (Rest # and AUV amount). The AUV amount needs to be placed on the Worksheet when the Rest # matches a Rest # on the worksheet. I have the following code, but it is not working.

Please Login or Register  to view this content.

[CK76]

I'd recommend uploading desensitized sample workbook.

Since Textbox returns all value as string data type, if the workbook range contains numeric value, it will not match.

If Rest# is unique, I'd avoid using Loop to speed up the process (ex: Use Application.Match() to return row# where match is found etc).

[brentjohn]

CK76,
Thank you for your advice.
Unfortunately, I cannot upload a desensitized sample workbook due to restrictions.
I confirmed the workbook cell range is set as "General".
Regarding avoid using Loop, I will research this method.

[CK76]

Cell range being set to General has little relevance here Numbers stored as General will be treated as numeric type.

What you need to ensure is that Textbox value is converted to appropriate data type if data stored in cell isn't a text string.

Using conversion functions CDbl(), CLng() etc.

[brentjohn]

I modified the Textbox value as follows, but still nothing is working.

Please Login or Register  to view this content.

[CK76]

What I mean is when you are comparing cell value against Textbox value, data type must match.

Ex:

Please Login or Register  to view this content.

[brentjohn]

CK76,
Let me look into this.
Again, thank you much!

[CK76]

You are welcome

[brentjohn]

CK76,
I tried running your code (in a separate macro located within the User form) and nothing hardened. Is your code needing to be within/embedded inside my code below?

Please Login or Register  to view this content.

[brentjohn]

CK76,
I found a work around until I rally understand your suggestion - again thanks!

[CK76]

Was out for the night. But yes, you'd use CDbl in your code like....

Please Login or Register  to view this content.