Links Corner Forum

cloeks1 wrote: ↑September 11th, 2022, 4:25 pm I downloaded new version of LVC and the zip file says LVC2022v3.zip and when I run it, it has none of the new features. Is the old version still at that download location or did I do something wrong.

Sorry, the perils of copy and paste.

The link is correct now.

Thanks for all your hard work on this Mike!

I'm running office 2019 and I get (run-time error 9), How do I fix this? Any help is

What were you doing at that time? What data were you entering?

Hi Mike,
I was entering courses and it will let me do a couple at a time then I get this run-time 9 error.

Entering new courses?

Sorry......yes entering new courses

When u get the error, can u click on debug?
It will take u to the code a hiloght the line in error. Can u post screenshot of that?
Did it happen when you were saving the new course?

I don't know how to do a screenshot of it but I am going to copy the text

Set course_name = Sheets("Courses").Columns("A:A").Find(TextBox_course_name.Value, , xlValues, xlWhole)

And yes it happens when enter a new course

radiodj wrote: ↑September 16th, 2022, 12:23 am I don't know how to do a screenshot of it but I am going to copy the text

Set course_name = Sheets("Courses").Columns("A:A").Find(TextBox_course_name.Value, , xlValues, xlWhole)

And yes it happens when enter a new course

Hi radiodj. Let me explain one way of creating a screenshot. Hopefully it works with all operating systems.

make sure whatever you want so save is showing on the screen, and then press the "PRINT SCREEN" key...

Now open a paint program (most operating systems give you a free simple one named "Paint")...

In the paint program, click on the screen and select "PASTE" (the hot key for paste is "ctrl-v" )...

It should paste a copy of the screenshot you took. Save it as a "jpg" and give it a name...

If you know how to use the Paint program, you can crop out only the image of what you want to save.

Hope that helps,

Dan