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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top