Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform, Find and Replace - Really Complicated
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 selecte in the ComboBox the information is inserted into a new row in th relevant 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 how do I go about it -- HelenMcKenzi ----------------------------------------------------------------------- HelenMcKenzie's Profile: http://www.excelforum.com/member.php...fo&userid=3669 View this thread: http://www.excelforum.com/showthread.php?threadid=56422 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Complicated (to me!) find and replace | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
Complicated Find Question! | Excel Programming |