Manually Edit Excel Cells while running macro

triplell89

Registered User.
Local time
Today, 05:50
Joined
May 21, 2009
Messages
21
So I have a macro that takes an email address from one worksheet and searches for it on a separate sheet. The second sheet contains contact names and phone numbers, which I want to add to the first sheet in a particular spot on the sheet. Is there anyway, that I can have the macro pause and let me edit the sheet manually, and then continue when I press ok(on a form, or something)...

I've been reading about forms, and I'm a bit confused as to how they work. Therefor, if you make a form suggestion, please help me with the coding.

Thanks
 
Hi, triplell89,

if form means UserForm (called by VBA) that would be okay, you could read the contents of the cell into a textbox and edit it there. Writing to the cell could be done by pressing a commandbutton on the userform.

Depending on if the values to search for are listed in a table/list they could be presented in a Combo-/Listbox on that Userform, the Find-Method could be used for searching, Offset for the resulting cellcontent to be delivered.

Maybe you can have a look at J & R Database Form... for getting a go for a solution.

Ciao,
Holger
 

Users who are viewing this thread

Back
Top Bottom