focus

Hey guys, My friend wanted a program for his employees that would allow them to input some data. The program would then just search an excel file for matches. If a match was found, then a message would be displayed that said "go ahead and do it." If a match wasn't found, then it would say...

Hi Guys I have a glitch in my program. It works fine only when i run it from the developer and the selected sheet is active. However when I launch it on the wrong sheet, it writes to the correct sheet but does not write in the correct row. Instead it writes to the second row everytime, deleting...

Is there a way to open and work other workbooks while a form is open? If a user has my forms running and wants to open another workbook... it wouldn't open until the form is closed... How can I avoid this?

Hi, I'm building a series of forms to work around a huge issue in the company, everything is working fine, but I just noticed that I cannot open any other workbook while my forms are active... How can I open other workbooks and have my workbook witht the forms running too? I thought about...

Hello. In my sheet activate code, I have a series of rows hidden, as shown below. Private Sub Worksheet_Activate() Range("16:364").Select Selection.EntireRow.Hidden = True 'Hides everything when the sheet opens End Sub I have check box controls that if a user clicks in a specific check box...

I'm running XL 2003 and I'm having some issues trying to get XL to automatically change the text in a button based on the user's choice from a ComboBox on an XL worksheet. I'm trying to get the number ouputted by the ComboBox (i.e., the "cell link") to trigger the Worksheet_Change event but...

Hi there! I've got a question from one of my college: He created a (multiple line) textbox containing comments on a spreadsheet. The problem is that, when the the textbox loose the focus, the first lines are displayed, no matter where the cursor was in the box. Therefore, my question is: how...

Hi all, I'm attempting to write a macro that will "loop until", down a given column (column a) until it finds a blank cell. Once the cell is identified I would like the focus to be on that cell and remain there until an entry/input is made by a user. Perhaps even a message box when a user...

I have some activex controls on a worksheet and I have noticed some odd behavior. Occasionally, the font size for these controls will change size (sometimes bigger, sometimes smaller) whenever my users click on the control. This is happening in labels, text boxes and buttons. I've searched...