Excel Com Addin

I did something similar (refedit in a userform shown from a COM Add-in)
using a 2nd userform. Using XL's InputBox didn't occur to me. Goes to
show how often I call on it. {grin}

Anyway, the files describing the technique have been added to the other
gazillion files in my 'tutorials for the website' folder. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <e3sJlVbbFHA.2756@tk2msftngp13.phx.gbl>, rob@analytical-
dynamicsdotcodotukay says...
> Roedd <<Tushar Mehta>> wedi ysgrifennu:
>
>
> > Further, and you may already know the answer to this, but I don't, one
> > should check the interaction between XL, the COM Add-In, and the XL
> > InputBox dialog box. Will it still be modal? I know that if one has
> > a userform in a COM Add-In, one needs to take special steps to make it
> > modal and to ensure it shows within the XL window. Further, it is not
> > possible to use a RefEdit control in such a userform. Well, one can
> > create one but it doesn't work. Does InputBox with Type=8 have the
> > same problem?
> >
>
> FWIW, I once created an ActiveX control for forms in VB6 dlls that emulated
> the RefEdit using a textbox, a commandbutton and Excel's Inputbox. It worked
> superbly. I was going to bring it up to commercial standard, but I didn't
> think the audience was there and then along came .NET
>
> <unhelpful>I have not the slightest idea whether a similar .NET control
> could be created.</unhelpful>
>
>

>>Yes, I know what you were referring to

Nothing personal Tushar, but I wasn't replying to you. It was a follow
up to the OP based on her comments above, subsequent to my first post.
The use of "Application" was just for the sample code - having a local
variable referencing the Application is fundamental with COM Add-ins so
I didn't think it was worth mentioning.

I haven't tried it, but through Interop the modality of the
Application.InputBox should be the same (i.e., non-modal).