idiosyncracies of user form
 

morning all.
I got my user form to work.
I now have some questions regarding certain elements of it.
1- I'm unable to activate the worksheet that I'm operating on once the user
form is active.
How do I code it in so I can click between worksheets?
I.e., if the worksheet is behind the form, I can just select the fields on
the active page. If the workbook is minimized, I must right click on the
toolbar for the file, and click restore.
I need to A- bring up the workbook if it's minimized, and B- click between
worksheets while my form is active.

2- While I agree that I may misunderstand some aspects, I notice that once I
select a cell, or range of cells-- using RefEdit-- and then select my next
range, the former range is no longer showing as having been selected. This
allows the user to lose track of where they selected, which can act to
confuse/obfuscate the ranges needed for my form/macro to work as desired.
Is there a way while the user form is actively going through all the fields
to have the ranges showing as having been selected-- apart from what's in the
RefEdit cells-- so the user does not get "lost"?

3- Once the user is done selecting all fields needed, and clicks OK how do I
"unload" the user form? Do I just place an "Unload.Me" at the end of my code?

4- What do I use to access the user form to begin with?
I know, this might be the stupidest question of them all, but I have to ask
to make sure I've got it right.

Thank you each for your helps.
SteveB.

idiosyncracies of user form
 

When you execute the command to show your user form, specify vbModeless for
the optional argument for the Show method...

UserForm1.Show vbModeless

--
Rick (MVP - Excel)


"SteveDB1" wrote in message
...
morning all.
I got my user form to work.
I now have some questions regarding certain elements of it.
1- I'm unable to activate the worksheet that I'm operating on once the
user
form is active.
How do I code it in so I can click between worksheets?
I.e., if the worksheet is behind the form, I can just select the fields on
the active page. If the workbook is minimized, I must right click on the
toolbar for the file, and click restore.
I need to A- bring up the workbook if it's minimized, and B- click
between
worksheets while my form is active.

2- While I agree that I may misunderstand some aspects, I notice that once
I
select a cell, or range of cells-- using RefEdit-- and then select my next
range, the former range is no longer showing as having been selected. This
allows the user to lose track of where they selected, which can act to
confuse/obfuscate the ranges needed for my form/macro to work as desired.
Is there a way while the user form is actively going through all the
fields
to have the ranges showing as having been selected-- apart from what's in
the
RefEdit cells-- so the user does not get "lost"?

3- Once the user is done selecting all fields needed, and clicks OK how do
I
"unload" the user form? Do I just place an "Unload.Me" at the end of my
code?

4- What do I use to access the user form to begin with?
I know, this might be the stupidest question of them all, but I have to
ask
to make sure I've got it right.

Thank you each for your helps.
SteveB.

idiosyncracies of user form
 

Hi Rick,
Thank you for the response.
I tried vbModeless, and once I selected a single range, it prevented me from
selecting any more ranges. In fact, it prevented me from doing anything else
on my form. I could not select cancel, ok, close the form using the X at the
upper right corner, etc.....
Once I commented that out, it worked fine. I can now select all elements.
So, whatever vbmodeless does, it appears that it doesn't work for my form,
or perhaps something within my form prevents it from working correctly.



"Rick Rothstein" wrote:

When you execute the command to show your user form, specify vbModeless for
the optional argument for the Show method...

UserForm1.Show vbModeless

--
Rick (MVP - Excel)


"SteveDB1" wrote in message
...
morning all.
I got my user form to work.
I now have some questions regarding certain elements of it.
1- I'm unable to activate the worksheet that I'm operating on once the
user
form is active.
How do I code it in so I can click between worksheets?
I.e., if the worksheet is behind the form, I can just select the fields on
the active page. If the workbook is minimized, I must right click on the
toolbar for the file, and click restore.
I need to A- bring up the workbook if it's minimized, and B- click
between
worksheets while my form is active.

2- While I agree that I may misunderstand some aspects, I notice that once
I
select a cell, or range of cells-- using RefEdit-- and then select my next
range, the former range is no longer showing as having been selected. This
allows the user to lose track of where they selected, which can act to
confuse/obfuscate the ranges needed for my form/macro to work as desired.
Is there a way while the user form is actively going through all the
fields
to have the ranges showing as having been selected-- apart from what's in
the
RefEdit cells-- so the user does not get "lost"?

3- Once the user is done selecting all fields needed, and clicks OK how do
I
"unload" the user form? Do I just place an "Unload.Me" at the end of my
code?

4- What do I use to access the user form to begin with?
I know, this might be the stupidest question of them all, but I have to
ask
to make sure I've got it right.

Thank you each for your helps.
SteveB.

idiosyncracies of user form- addendum
 

I appear to have solved my first question. Part of my problem was that I had
a series of screenupdate elements in my original macro so that I didn't have
to spend time watching various formatting procedures occur. Once I commented
them all, item 1 is resolved.


Question two is still of interest.
For further explanation, when we place a worksheet function in a worksheet,
when a range, or cell is chosen, it's "highlighted" by a colored outline of a
box for that range of cells. If one chooses a series of individual cells,
there are multiple colored boxes.
This is what I was looking for, so that the user could keep clear what
they'd chosen while going through the user form.
Is there a means that I can have these colored outlines, on the worksheet
while I'm selecting ranges for each of my RefEdit elements? If so, how? Is
this located in the properties box of each RefEdit element?



"SteveDB1" wrote:

morning all.
I got my user form to work.
I now have some questions regarding certain elements of it.
1- I'm unable to activate the worksheet that I'm operating on once the user
form is active.
How do I code it in so I can click between worksheets?
I.e., if the worksheet is behind the form, I can just select the fields on
the active page. If the workbook is minimized, I must right click on the
toolbar for the file, and click restore.
I need to A- bring up the workbook if it's minimized, and B- click between
worksheets while my form is active.

2- While I agree that I may misunderstand some aspects, I notice that once I
select a cell, or range of cells-- using RefEdit-- and then select my next
range, the former range is no longer showing as having been selected. This
allows the user to lose track of where they selected, which can act to
confuse/obfuscate the ranges needed for my form/macro to work as desired.
Is there a way while the user form is actively going through all the fields
to have the ranges showing as having been selected-- apart from what's in the
RefEdit cells-- so the user does not get "lost"?

3- Once the user is done selecting all fields needed, and clicks OK how do I
"unload" the user form? Do I just place an "Unload.Me" at the end of my code?

4- What do I use to access the user form to begin with?
I know, this might be the stupidest question of them all, but I have to ask
to make sure I've got it right.

Thank you each for your helps.
SteveB.

questions 1, 3, and 4 solved.
 

Hi again.
I've resolved questions one, three and four.
I just need my second question resolved now.

question two restated:

For further explanation, when we place a worksheet function in a worksheet,
when a range, or cell is chosen, it's "highlighted" by a colored outline of a
box for that range of cells. If one chooses a series of individual cells,
there are multiple colored boxes.
This is what I was looking for, so that the user could keep clear what
they'd chosen while going through the user form.
Is there a means that I can have these colored outlines, on the worksheet
while I'm selecting ranges for each of my RefEdit elements? If so, how? Is
this located in the properties box of each RefEdit element?

Again-- thank you for your helps.