Error 424 : Object Required

Hi, hopefully someone can help me, as I am perplexed by this.

I have a form from where I am trying to create a value for something called F** - This is basically to check if the spreadsheet has a yes or no in a certain field, if it does, then a tick will be placed in the relevant check box.

I have some data already inputted and it works fine (see below for code)

But when I try to add F21 in I get an object required failure. I have copied and pasted from the line above(F21), change to F21 or any random name and the issue still appears. Please help

Please Login or Register  to view this content.

Does anyone have any ideas on this, as I still can't work it out?

I have no control called F20 that I am aware of.

All this is doing is taking the value that is already in the spreadsheet and using that value to determine whether the check box should be ticked or not. I have no control is the code at all.

Hi

The form has 40 check boxes, and each one of them I have called F1 -- F40, only so I can show the check box as true if the cell contains the value yes, or unticked for the value no.

Hope this helps.

Sorry the Controls are actually called feature_check1, 2 etc etc

The F1, 2 etc are used solely to pull the content of the cell into a value, that I can then determine to show the box checked. see below

Please Login or Register  to view this content.

So basically F1 will take the value of cell A20 in the PSTN worksheet and if that value is Yes then the checkbox Feature1 will become ticked, and if the value is No then the checkbox Feature1 will remain unticked.

This goes on and on until the 40th cell is checked. i have so far included all up to F20 but as soon as i enter the code for F21 I get the issue. I have tried with different names to F1, for example, featurevalue1, value1 etc etc and this does not work either.

I am not fully clued on on VBA and excel, but I am managing ok, but this has me stumped

Originally Posted by VBA FTW

Sounds like you don't have an object that's named F21 on your form, add another textbox and change it's name to F21, also, since you're using textboxes, shouldn't you be using .text instead of .value?

Thats it, thank you very very much.

I suppose that's what happens when you start a project, stop and then continue after 2 months of doing nothing.

Feel quite embarrassed right now lol

Thank you very much Norie and VBA FTW for your help.

Norie, I have a textbox labelled F1....... etc and I have not put that in for F21 -- F40 (what an idiot)

I did look at a list box, but it would not have been appropriate for what is needed.

This now works perfect, thank you.

Back to the grind and coding then i suppose

Thanks for that Joeseph - That has helped me loads

I will now have less worn out finger tips with thanks to that

Well I have 43 checkbox's in total, and some of them will have other options once ticked, and some checkbox's will not be available unless another option is checked.

For Example
If you check box 31 then you be required to enter a telephone number.
If you check box 22 then checkbox 40 will appear, if 40 remains unchecked you will be prompted to enter a pin number and if 40 is checked then a password will be required to entered.

A bit long winded so it just seems easier to use checkbox's - bearing in mind my VBA knowledge was 0 at the start of this project

No unfortunately not

Plus you haven't met the guys that will be using it... not the sharpest tools in the box, so the simpler the better lol