cell location

  1. V

    combobox selects cell and text box info updates corisponding cell

    Hello, im not sure how to code this (obviously lol). i have a simple user form that has 1 combox that lists all items in column a. I have a text box that lists the text in column next to it (column b). what im not sure how to do is to let the user type in a new item into the combobox and text...
  2. J

    Userform to specific, and set location on worksheet.

    I have a Userform, Height 675, width 519 that I want to place on a specific worksheet, (Sheet1) but have it stay on one location on that sheet only. I want it to be in the center of the sheet (any range for now), but have it stay only on that sheet and only in that location. Is this possible...
  3. L

    Search entire spreadsheet for Value, Return Cell Location

    Is there a formula to search the entire spreadsheet (or a range) for a value and have the cell location returned? For example: | A | B | C | 1| William | Bill | Willy | 2| Richard | Rich | **** | 3| Steven | Steve| Stevy | 4| Harold | Hank | Harry | Sheet1 I know...
  4. 7

    VBA Positioning Code

    I'm putting together a macro in Excel 2007 (Windows XP) to paste some data in a cell range that feeds a graph. Is there a vba code that will change what cell is selected one column to the right (Example: Current selected-cell is A9 -- there is already data in this cell-- I would like to...
  5. 7

    VBA Positioning Code

    I'm putting together a macro in Excel 2007 (Windows XP) to paste some data in a cell range that feeds a graph. Is there a vba code that will change what cell is selected one column to the right (Example: Current Selected cell is A9, I would like the selected cell to be one to the right, or...
  6. E

    Name A Cell in VBA

    Afternoon all, Within my macro I have looped downwards to find the next empty cell. I then need to go back to this cell location (i.e. B6) later in the macro and many times. How can I go back to this cell location without performing the loop again? (which will make the code long and make the...

Some videos you may like

This Week's Hot Topics

Top