How to position pop up on a particular location on screen

**Scofield24** · 07-19-2013, 05:45 AM

Hi All,

I have a worksheet which contains several option_buttons(YES/NO). On clicking YES(say), a pop up shows up instructing user for his next action.

I need to control the pop up location on screen.

For Example:
For Option_button1 in cell A1(say), the pop up appears in front of it, in cell D1(say).
.
.
.

For Option_button25 in cell A25(say), the pop up appears in front of that,in cell D25(say)..

I hope i'm clear in my explanation.

Kindly advice.

Thanks

**Andy Pope** · 07-19-2013, 05:48 AM

See Chip Pearson's article
http://www.cpearson.com/Excel/FormPosition.htm

**Scofield24** · 07-19-2013, 05:54 AM

Hi Andy,

In the link u provided, Chip applies this concept on Userforms, whereas i'm using Msgboxes. How to do the same in MsgBox?

**Andy Pope** · 07-19-2013, 05:57 AM

doing it for a userform is much simpler than for the built in msgbox, which does not have position properties,

but if you want you could try
http://www.excely.com/excel-vba/defi...l#.UekNR23wrDE

**Scofield24** · 07-19-2013, 06:08 AM

ya... i viewed this link earlier. Sadly, couldn't understand it.

Actually as i mentioned above, i have many option_buttons in my worksheet. So creating userform for each of them will get complex.. That's y thought of avoiding it..

**Andy Pope** · 07-19-2013, 06:11 AM

Why would you need a userform for each button? Simply load the form, update a label with the requried text and then show it at the require position.

**Scofield24** · 07-19-2013, 06:19 AM

I'm sorry , but i'm a beginner in excel/vb...Could you guide me how to create userform and do it?

Thanks in advance

**Andy Pope** · 07-19-2013, 06:20 AM

can you post an example of what you have so far?

**Scofield24** · 07-19-2013, 06:35 AM

Sadly No, because its a confidential thing.. u may give an example with two-three option buttons using single userform(as u said earlier).. I will try an apply it on the entire sheet..

thanks.