Pausing vba until click

[SrPuma]

hi, ive been posting for some time now questions that no1 doesnt even say(i dont know xD) lately...since i think there might be someone around there that might know what i ask this time...

I would like to know if there i s a way to pause the vba from moving foward untill something is clicked..like a tree node...
I would really appreciate if someone could help me...(drop by even to say "!i have no ideia" xD)

 

[namliam]

No... You can pause VBA in 2 ways (that I know off)
1) Popup dialog form
2) Msgbox

Waiting for anything else to be clicked you will have to make "on click" code of that object to restart/continue code....

 

[SrPuma]

maybe i didnt made myself clear..what i want is the program to wait till i click on a tree node in order to obtain a value that is displayed after the click on a text box

 

[namliam]

You made yourself perfectly clear... And as far as I know... it cannot be done unless via 1 or 2
And possibly if you can use the "on click" event of the object ...

Other than that this "advanced user" does not know... Maybe some MVP may know more/better, but me?? Sorry...

 

[SrPuma]

i tried with a msgbox but i cant click aything else when it appears and about the popup dialog i have no ideia how it works....(this is what happens when a boss wants a *how should i put this* phone builder to build a plane)

 

[namliam]

LOL

Yes mesage box blocks everything but the messagebox...
The dialog form is a popup form which you open using DoCmd.Formopen
This tho works (more or less) the same as the msgbox, blocking your other form(s). Tho on the dialog form you can add the Tree view you want clicked, allow it to be clicked and pass back the data to your code somehow.....

 

[SrPuma]

Well thats all good...but the tree is already on the form and making it load once more onto another form would turn it too slow since its loading a network directory :S

 

[namliam]

Those are the options I know... Sorry... You asked to respond even if there wasnt a known solution, so I provided what I know to be the possibilities, never claimed them to be perfect.

 

[SrPuma]

i know and i thank ur time in trying to help me even if it wwouldnt work so well