Search results for query: *

Thank you Skip and Loomah for your responses. I found a some tips online that answered my question and here is the code in generic form: ************************************************************ Private Sub UserForm_Initialize() Dim i as Integer Dim workbook1 as Workbook With...

Hi, Can someone please help me? Thank you for your time and help in advance. I have a combobox in VBA that belongs to workbook1, and I want the combobox in workbook1 to list all the sheets of workbook2 (which is a closed workbook). Here is the code I have so far...

Actually I've never thought of that approach. So, the search phrase or keyword has to be static, right? Which means I have to pre-programmed the phrase and keyword using VBA, and update the VBA modules when there is a change? If it is so, I will try and let you know. Thank you for your help...

Yes, I have XP. I've read some article on microsoft.com which mentioned that you can make the workbook become interactive workbook and upload the Web page Excel (in XML)using Office 2003 quite easily, but I did not think you can do the same things in Office 2002. I am about to download MS...

Thank you for your response. I have tried to save the workbook as Web Page, but this makes the workbook become static information display tool. I want the the workbook to be interactive; which means users can change value and search for certain information on the Web. DDTiff

There are a number columns I want to be able to search the phrase and keyword. For example, in column B I want to be able to search for "what is the budget"; and column F I want to search by keyword such as company name/branch name something like "Lockheed Martin" or "LM" or "HR". Once the...

Hello Everyone, Can someone please tell me the best way to approach the process I want to develop? Thank you in advance for your time and help. I would like to transform multiple workbooks in Excel to become a Web-based interface that allow user to perform "what if" analysis; add/delete...

Hello Everyone, Can someone please help me? Thank you in advance for your time and help. I have a workbook in Excel, and I want to be able to search the rows in the worksheet by phrase and keyword. Once the phrase or keywork in the worksheet is found, the worksheet should be filtered so that...

Mike, My goal is that I want to be able to tell what information is old and what has just been added (information configuration control). The first solution only let me turn on and off the color of the row when the row is either empty or not. It doesn't tell me whether the information is new...

Yes, I did. I thought there is another way to track using the conditional formats. Maybe tracking changes is the only way. Please let me know if you have another way come to mind. I appreciate your time and assistance. DDTiff

Hello Again, I have another question that I have been trying to figure out for two days. If my worksheet already has data in it, and I want to change the font color of any row that used to be empty and now has new added information. For example, the information that I entered previously...

Mike, it works like a charm. Thank you very much for your help and time.

Thanks Mike for your response, but when I added the formula into the Conditional Format, only the cell "A1" changed color. What should I do to change so it reponds to the whole row? Thank for your help.

Hello, Can someone please help me with this? Thank you for your help in advance. I have a worksheet, and I would like the row color to change from white to green when a user enter information into a blank row. I have tried to enter this formula into Conditional Format Formula...

Matt, Thank you for response, but the code did not work because I want the checkbox to check and uncheck automatically when one of the condition is true or false. I wall try using Status_AfterUpdate & Status_BeforeUpdate (these two are not applicable to checkbox)event but that still did not...

Hello, Can someone please help me? I have a question about checkbox enabled and disabled capability. I would like to thank you in advance for your help. I have a table call 'Items' with 'Status'; 'Due Date'; 'Overdue' and many other fields, but the condition only involves Status; Due Date...

Sorry for getting Becca and Rob names confused. I look forward to hear from one or both of you. Thank you in advance for your help. DDTiff

Hello MsBecca, I have created a similar login form like Rob. But, I also would like to allow the user to change the password by creating a new form for changing password. The new form is called "ChangePassword" with three textboxes: txtoldpsswd; txtnewpsswd; and...

Skip, So you mean, if you enter "test" into the "txtnewpsswd" and click the "Change" button; the value of the "txtEOPW" value now be "test" instead of "execoff"? Therefore, if next time you open the "Login" form, you should...

The following codes are for the "Login" Form: Private Sub cmdEOLogin_Click() Dim psswd As String psswd = "execoff" If txtEOPW.Text = psswd Then rsp = MsgBox("Congratulation! You are a valid user!!", vbOKOnly, "Corporate Login") If rsp = vbOK Then...