Inputbox for address doesn't show

[zplugger]

This code will get stuck when reading addressbook for email address, the dialog box for address will come up if you click cell on sheet? Need it
to show no email address quicker without clicking sheet? Works Perfect if email address is in the addressbook.
Only hangs up when there is no emailaddress in the book for person your trying to send too.

Please Login or Register  to view this content.

[zplugger]

For some reason this is the hang up ,input box does not pop up on screen unless you click somewhere on page?

Please Login or Register  to view this content.

[zplugger]

Any suggestions,know code try's to work because if I click on sheet it will show inputbox

[zplugger]

Having problems with this part of code,what can I add to code when I click cancel on inputbox to shut down the maco and quit running rest of code. When I click cancel it messes up the whole workbook,like a macro is running and have no control. ???

Please Login or Register  to view this content.

[Winon]

Hi zplugger,

Please clean your glasses and see what you have done!LOL

Please restore this section of your Code first, and see if it helps.

This is fine!

Please Login or Register  to view this content.

Now before "End Sub", insert;

Please Login or Register  to view this content.

This is taking it step for step.

'Till later

[zplugger]

How did that Happen LOL Nice catch Winon.

[zplugger]

Just got to get the input box to come on screen when no address found? it will only show if I click the page, but sometimes it works ??? Driving me nuts.

[zplugger]

Wonder if a userform inputbox would be better?? Not sure how to get the code in post #4 into a userForm inputboxBox? The other box works but does not come on screen without clicking worksheet. Have other message boxes in the workbook and they all work?