Help
Hi,
Can I get the text from the text box and it actually higlight the range of the cell based on the text key in. After highlight the cell, it actually delete the range of the cell. tks. regards, Joe |
Help
stext = userform1.textbox1.text
celltext = ActiveCell.Value I = InStr(celltext, stext) If I 0 then _ activecell.value = Left(celltext, I - 1) & Mid(celltext, I + 1) Robert Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Joe" wrote in message ... Hi, Can I get the text from the text box and it actually higlight the range of the cell based on the text key in. After highlight the cell, it actually delete the range of the cell. tks. regards, Joe |
All times are GMT +1. The time now is 01:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com