Userforms and Cell Selection

[MediocreJoker]

Hi Everyone,

I've got two things I need help with:

1. Userforms

So right now I have a form that shows as this:
\1

I'm trying to make it so that when they hit enter, the form is hidden. My code:

Please Login or Register  to view this content.

And it doesn't work. And while I'm here, how do I make the form show up at pos x,y?

Also, is there a way to remove the form from memory after I save the desired values, instead of simply hiding it?

---

2. I've also got a question about selecting cells. Basically I have 2 spreadsheets. The first one is a data set with 2 columns, Owner and Process and it looks like this:

Some header text
More random text
Owner Process
A ||||||||| blah
A ||||||||| something
B ||||||||| 324
B ||||||||| nothing
B ||||||||| something else
C ||||||||| bleh
D ||||||||| hello
D ||||||||| text

I'm trying to make a macro for a 2nd spreadsheet, where it will create a worksheet named after each owner (So 4 worksheets will be made), and in each one the processes owned will be listed in Column A starting from row 3. How do I reference other spreadsheets/worksheets, and how do I specify for it to start searching from the 4th row (ignoring all the header text)?

Thanks for any help!

[MaczaQ]

Ad1 try this way:

copy it into userform code

Please Login or Register  to view this content.

display position:
set property for your UserForm
- StartUpPosition = 0- Manual
and then you can use this:

Please Login or Register  to view this content.

Best Regards

[Mordred]

There is a lady at my work that has a workbook with at least 12 forms in it. Instead of unloading each form after showing the "next" form, she used the hide method. She was having a lot of problems and asked me for help. Among other solutions to her problem, I asked her to use the unload me command to see if it made a difference for her and it did. I don't actually know if that was the solution to her problems because of the other suggestions I gave her, but I thought that hiding forms could be problematic. The only time I use hide/unhide is with frames.

[MaczaQ]

Ad 2. check attached solution ... I think all your conditions are covered.

Best Regards

[MediocreJoker]

Thanks! Your solution for #2 was a great help.

However, I still cannot get the userform working.

Please Login or Register  to view this content.

The userform won't go away after pressing Enter (is it KeyCode 13?)

Edit: I just tried bashing my "Enter" key twenty times and it worked, once. Why does it take so many tries?
Edit2: Hmm, after playing around with it, it seems to work consistently if I press Enter at the same time as I click the NameEntry box. What is wrong with this lol.

[snb]

I'd prefer:

Please Login or Register  to view this content.

[MaczaQ]

AD 1.

Please check my working example (attached file) - it have to work.
I suspect that you have to many code lines in your project

Best Regards

[MediocreJoker]

OK, your file works, but I'm VERY confused.

Basically, I dragged your Userform into my worksheet. It Works. I dragged my Userform into your worksheet, it works. I tried my userform in my worksheet, it doesn't work.

I've attached my spreadsheet. If you test your userform it works. if you test my userform, it doesn't. This is in the SAME spreadsheet with the SAME code. Why is this happening ;(

[MaczaQ]

in your userform you use "me.hide" whilst you should use "unload me"

best regards