Text box to encode information to worksheets.

[joromajr]

-- Hi all,

Badly need your help. My Boss has an eye problem and is requesting a text
box where he can encode and search.

In sheet1 contains account name, Invoice number, invoice dated and Invoice
amount. On Sheet2 account name, Invoice number, Invoice amount, Check number,
check date, and balance amount.

His request, one text box to parts. on first half is the encoding half,
sections to encode individually account name, invoice number, invoice date,
and invoice amount and a accept button. Second half is the search half,
sections to encode account name and invoice number with search button.

On first half of text box when accept button is click data encoded in the
sections will be sent to sheet1 in proper column and row. On second half
after encoding account and invoice number and search button in clicked the
screen will go to sheet2 to the account name have that invoice number.

Please help need in badly.


joromajr

 

[joromajr]

-- can any of the experts please help me?
joromajr