Help endiing my code

[welshman010]

Hi

Sorry for the vague title, didnt know what terminolgy to use. I have the following code

Please Login or Register  to view this content.

It works perfect if I leave out

Please Login or Register  to view this content.

New to VBA and been making do with asking questions, finding examples etc. What i need is on button click it do the above then get value from S10 on sheet calc

Some help be great

[Richard Buttrey]

Hi,

Leave out 'Next' and try

Please Login or Register  to view this content.

[welshman010]

I get object doesnt support this property or method.

First part of code is inserting values to sheet to perform calculations then the last part of code was to retrieve the finished calculation

[Richard Buttrey]

Hi,

Perhaps you'd better upload your workbook so that we're not all guessing what you mean.

[pareshj]

Hi welshman010,

As per your code in post #1,

Please Login or Register  to view this content.

Just check your code, you have period before TextBox7.

Try this code instead:

Please Login or Register  to view this content.

Regards,
Paresh J