Userform Search

[HelenMcKenzie]

I'm relatively new to VBA and am probably trying to run before I ca
walk but I'm hoping someone will be able to help me figure it all out.

I have a workbook with 4 different sheets, Alpha, Beta, Gamma, Delt
and in each sheet there are 5 different columns, Account Number, Name
Status (Stopped / Off Stop), Date Placed on Stop, Date Taken Off Stop


I have created a userform for entering new data. In this Userform
have a ComboBox for the sheet names, a TextBox for the Account Number
a ComboBox for the Status, a TextBox for Name, a TextBox for the Place
on Stop Date and a TextBox for the Taken Off Stop Date.

I have part of my Userform entry working. When "Stopped" is selected i
the ComboBox the information is inserted into a new row in the relevan
sheet.

What I can't get to work is:
When "Off Stop" is selected I want it to search, in the relevant sheet
for the Account Number that was entered in the TextBox in the Userform
I don't want it to do anything with the account number it finds bu
rather replace "Stopped", that is in the same record and in the Statu
Column, with "Off Stop". I also want it to insert the date that wa
entered in the "Taken Off Stop" TextBox in the Userform, into the "Dat
Taken Off Stop" column , and then I want it to cut the entire row an
paste it in row 4.

Is this possible? And can anyone give me a head start

 

[raypayette]

I believe that your answered your own question!

 

[HelenMcKenzie]

I'm not sure I know what you mean!!

I have tried everything I can think of to get this to work for me but I
don't seem to be getting anywhere. If you don't want to point me in the
right direction, maybe you could just tell me if it is actually possible
to do this so that I don't continue my search in vain.

I'm really hoping you can be of some help.

Regards,
Helen

 

[raypayette]

I am trying to help you, but programming UDFs with many controls i
complicated. I can recommend the Visual Basic Black Book that explai
in detail exactly what to do for all of these forms and controls. I
isn't very complicated, but it is long and tedious

 

[raypayette]

I am trying to help you, but programming UDFs with many controls i
complicated. I can recommend the Visual Basic Black Book that explai
in detail exactly what to do for all of these forms and controls. It i
long and tedious

 

[raypayette]

I am trying to help you, but programming UDFs with many controls is lon
and tedious. I can recommend the Visual Basic Black Book that explain i
detail exactly what to do for all of these forms and controls