vba excel Modeless Balloon

Hi guys,

I have a balloon that I am trying to make modeless so my users can interact with the spreadsheet without dismissing the balloon, but when I set the type to modeless, the balloon disappears as soon as I call the procedure.

TIA!

SCott
bfreescottAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EDDYKTCommented:
You can set your form always on top

ie
Const SWP_NOACTIVATE = &H10
Const SWP_NOMOVE = &H2
Const SWP_NOSIZE = &H1
Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal X As Long, ByVal Y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long

SetWindowPos Me.hwnd, -1, 0, 0, 0, 0, SWP_NOACTIVATE Or SWP_NOMOVE Or SWP_NOSIZE
0
bfreescottAuthor Commented:
is there no way to do this in vba without using the API??
0
Rory ArchibaldCommented:
Do you have a callback procedure set?
0
bfreescottAuthor Commented:
no, i was looking at that though.  do you think that's what i need here??
0
Rory ArchibaldCommented:
Yes - as far as I know you cannot have a modeless balloon without a callback procedure. Note also that the callback must take three arguments, a Balloon and two Longs.
Rory
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.