vba form with buttons

Microsoft Office 2000 standard
May 2, 2010 at 14:41:28
Specs: Windows XP
I know it's a big ask... but

User responds to query on phone
Inputs at least 3 characters into any or all form textboxes
Clicks Search button
User can then make a decision based on account history

If it helps here is the sample workbook

Form contains 3 textboxes and labels
1 Name
2 House No / House Name (No)
3 Address

Form contains 2 commandbuttons
Button 1 function - Search
Search criteria- a single form entry or any combination of entries
Search ("Accounts") copy results 'Transposed' to ("Reports")

Button 2 function - Accept - (user discretion)
If exist select the column where 'Instruction Row' starts with ZPP
Else select the column with most recent 'Delivery Date'
Within the selected column highlight following rows for Copy
Title, Name, No., Address1, Address2, Postcode,Phone No.and Instructions
Paste 'Transposed' to Sheets("Accounts") on row below last entry

See More: vba form with buttons

May 2, 2010 at 14:42:47
sorry I am using MS Office 2002

Report •

May 2, 2010 at 14:57:16
I messed up the link above here is one that works (I hope).
If all else fails I can PM you the link.

Report •

May 3, 2010 at 13:27:43
Please IGNORE this whole topic.
I have solved some of my queries - by myself!!!!!!
Wonders never cease.
Thanks to this forum and the knowledgeable people who give guidance I can do some vba coding myself.
However, I'm sure I will be back with more problems.

Report •
Related Solutions

Ask Question