VBA Code does recognise value in a cell if value is provided by formula.

[bretthullah]

Hi All,
its been along time since I visited this forum. I need some assistance please.

I have a form that inputs data into a worksheet and it also allows me to change the data in any record (line of data) l select. This is done using a combo box on the form selecting a unique number that I have given each record. The column where the unique number is stored comes from another worksheet in the same workbook which is a obtained by a formula.

When I use the combo box to select the specific unique number I require they all show up and I can select the unique number that I want and all data associated with that number is visible and can be changed.

When I press the submit button on the form I get the Run-time error '91' : object variable or with block not set

If I was to manually type the unique number into the column where they are stored and use the form it works perfectly. So I believe the code is not recognizing the value that the formula is inputting as a valid piece of data. I think!

thank you.

Here is the code. I hope I am doing this correctly.

Please Login or Register  to view this content.

[Pepe Le Mokko]

Code tags added by OP

[bretthullah]

Thank you. I have made the change
cheers

[nilem]

Hi bretthullah,
try something like this instead of using Find

Please Login or Register  to view this content.

[bretthullah]

Thanks nilem. I will give it a try.

[bretthullah]

Hi nilem,
I have tried using the code you provided. It partially works.

The form will only input the data for txtNetWeight.value , anything after ie txtRate.Value and so on remains blank

Please Login or Register  to view this content.

[bretthullah]

All sorted nilem. The problem was my typing. It works great Thank you.
Cheers

Below is the working code

Please Login or Register  to view this content.

[bretthullah]

my problem has been "SOLVED"