Input box not allowing mouse clicks

**tryer** · 04-30-2011, 02:51 AM

Sorry about this I am asking a lot of questions about code not working with excel 2010

I have the code below which displays an input box asking the user to select a destination row. When used with office 2003 you could click on any row and the range was automatically filled in on the userform. When using this code on excel 2010 the userform is displayed ok but whilst the form is visible no mouse clicks (outside of the form) are accepted.
Is there a way I can modify this or if not an alternate way of the user selecting a row without having to type in its address?

Please Login or Register  to view this content.

**pike** · 04-30-2011, 05:26 AM

hi tryer
with the userform properties change
showmodal=false
to allow worksheet selections
can you please fill in your user profile
Location and MS version

**tryer** · 04-30-2011, 07:32 AM

Thanks Pike,

I'm using an inputbox which I don't think I can set the properties on? However I can checnge this to a userform following your suggestion.

Profile completed

**pike** · 04-30-2011, 07:42 AM

the userform is showing and you call the input box

"When using this code on excel 2010 the userform is displayed ok but whilst the form is visible no mouse clicks "

The setting are on the userform to allow the input box to work

**tryer** · 04-30-2011, 10:51 AM

I've re opened this thread because I'm obviously not getting something right here.
When I set the showmodal = false then as you said I can then click with the mouse however the routine continues to run rather than wait for an input.

What I need is a box to display asking the user to select a row. once this selection is made I would like the row number to be available and at that point for the routine to continue.

**pike** · 04-30-2011, 09:37 PM

Hi tryer.
Remove the "on error resume next" to see where/if there is an error
what the complete code you are calling from the userform?

**tryer** · 05-01-2011, 02:05 AM

Pike, I really appreciate your help and patience here. I have (finally) solved the problem and can't believe I was so stupid. I had screen updating turned off at the begining of my code.
I only found this out by cutting out the section of code in order to post a sample workbook for you only to find in worked OK on its own but not within my whole routine.

Again thank you for your replies