Search results for query: *

Hi all I have a combobox with 2 columns. I need it to be filled with Names in col1, and Email in col2. The data comes from an Excel sheet. We find the row relating to the specific customer, then grab the data, starting at column C. The data is stored: NAME1 EMAIL1 NAME2 EMAIL2...

Hi all I need my userform to open an additional file for input. The file is on a network drive, so I need to perform the following checks: 1) the current user hasn't already got the file open in the background (this works) 2) another user hasn't got the file open (which would open in...

Hello I have a project with a couple of forms with quite a few controls spread over a couple of userforms. I haven't hit any maximum limit yet (there's no more to add), but I was wondering - controls on worksheets contribute to the maximum? I did have certain sheets that get duplicated, which...

Hi all I'm trying to move 2 sheets from the master document into a new document, save as, and close, with no input from the user (file names, folder etc.) The 2 sheets have several buttons with code on. When I try to copy the sheet over, it retains the buttons and code. I've attempted to use...

Hello I have a column (H) that is formatted to Wingdings font. When the user double-clicks, it inserts a tick (Wingdings = ü). There is also a conditional format on the column - if the cell is not empty (ticked), it is white; if empty, it is yellow. How do I make the adjacent 3 cells also...

Hi I have a calendar/diary page with the dates horizontally (Mon>Sun), then several rows underneath the following week, and so on (basic diary layout). I need to find the specific date (got this part), then write data underneath it. The cell below can either be empty, or full. However, if...

Hello I'm trying to move a worksheet to a new workbook (thus removing it from the original workbook), save the new workbook in a folder, then close it, and come back to the master workbook. I found this code on a website a few weeks ago (since lost). It works okay sometimes, but as the...

Hello I'm trying to import a sheet from another workbook (this part is fine). Let's say import Sheet1 from workbook B into workbook A. The issue is when workbook B is opened, it runs a subroutine that results in a MsgBox. Is there: a) a way to surpess this MsgBox only when importing the...

Hello I'm trying to find a string within a range, but only if the offset matches. For example: I need to find the last occurence of, let's say, Cat 6. COLUMN A COLUMN B Cat 1 Cat 6 Cat 1 Dog 4 Cat 6 Dog 3 Dog 8 Cat...

Hello I'm having trouble with this: I need to locate any green (5296274) or yellow (&HFFFF&) cell within a range (A1:AZ300) on a specific worksheet ("DATES") I then need to return the offset (col +1) for each (likely loading them into a standard listbox). I've been trying to adapt this -...

I'm trying to select a specific worksheet upon exit of the userform, but it's generating the error 'Type Mismatch'. The name of the form is loaded into a textbox named textQuoteNo. This is populated from the actual sheet the userform is loaded from. As the form fetches data for comboboxes...

Hi. I have a problem using Selection.End(xlUp) - I need it to disregard cells with formulas in. I've tried to substitute for a Do-While loop but it has the same effect (albeit with a different outcome) Do Until ActiveCell.Value = "" ActiveCell.Offset(-1, 0).Select Loop

Hi I need to add a dynamically sized range from a row in excel into a listbox (column 1). The range will always start at G1, and end at whatever the last used cell is in row 1. I can do this fine when adding a column using this method: Dim rngC As Range With Sheets("Customers")...

Hi, I'm trying to filter a listbox based on a specific column. It's a 2 column listbox, loaded from a range of 3 columns. Column 3 is the category (let's say A, B, C, D etc.) How would I approach filtering/displaying by category? eg. click on the Category A button, and only category A items...

Hi, I have a button on multiple pages that I need to place a hyperlink back to the page it came from. The hyperlink will be placed on the first worksheet, called Overview. [code] Dim TargetSheet As Worksheet [highlight #73D216]I've tried both of these and other things but none work[/highlight]...

Hi, how can I make a spinbutton alter a TextBox with the date format "ddd dd-mmm yy" (Tue 19-Feb 13). I can make it work for just the date (and another textbo for the time works fine), but how would I add the day of week into it? Private Sub UserForm_Initialize() txtDate.Text =...

Hi, this should be simple but I'm having no luck. Search down column A for a string, then load that row into an array (not including A, just columns B-the end).

I have a set of addresses that are 3-5 lines, that go into various worksheet cells that are often 2, 3 or 5 lines. The cells they go into are merged cells. How would I use Replace() to replace the vbNewLine with ", " but only on certain occurrences? For example the address is stored in this...

I'm attempting to search Row 1 of a sheet for a string in a combobox. This works fine with my code for searching down a column for a string, but searching the row it only works up to Row Z. From Cols AA-AZ it loads column A, and BA-BZ it loads column B. Once it has found the name, move down...

I have a sheet with 4 columns that can be sorted with a Table listobject by Customer name. There is a worksheet for each customer. I need my macro to select each customer in the Table, and copy their data to their own worksheet. I've got this working for 1 customer, but this method would...