define

  1. S

    Variable Problem VBA

    Hello, I have started a small code in VBA but can't get this simple loop to work. I am creating a UDF function with multiple input Ranges. I then want to loop in those ranges but VBA don't seem to recognize the ranges. Here is the code: Function NPak(Lookup As Variant, ORange1 As Range...
  2. L

    How to define a range based on the cell value

    Hi, I'd like to define a range and include only the entries that have a certain code in the cell next to them. So my data looks like this: A B C D E 4 x 3 y 2 x 1 y 5 x So I need to define a range in vba and have the range be equal to the collection of cells in column A that have an "x"...
  3. K

    VBA: using the output number a defined cell

    I'm trying to unhide rows one at a time using VBA, I have found some code that will do this, but the starting row that I want to unhide changes and I want stop unhiding at a dyanmic row as well. The code I've been using is below, and I'm trying to modify "a1" and "a100" to reference two...
  4. J

    Renaming Form Buttons

    Hi there, I want to rename a form button. This is separate from editing the text inside the button. When I click on the button, go to insert/name, the underlying name is different from the text entered into the button. How can i redefine the name of the button?
  5. L

    Basic Question - Excel Macro how to Define Range in For, Next

    I have some code that I run and a part of it says: Do While OX > 0 For g = 08, 11, 14, 17, 20 . . . Next g So I'm getting an error at the "For g" row because I'm sure I have the construction wrong. So how can I define this range so that it steps through (first g = 8, then at the "next g" it...
  6. P

    How to create a smart split?

    Hi, thanks for taking the time to look at this. Have looked high and low so hopefully someone here can point me in the right direction. I am on XP, Excel 2003 or 2007. I need to split a description field provided by suppliers in their varied formats into pre defined columns so that I can...
  7. R

    specific compile error

    I get the following error when I run my code: "Compile error: User-defined type not defined" VBA highlights this line of code: Public msg As New TibrvMsg I think maybe I'm missing a reference or something in tools/references. Any recommendations? Thanks!
  8. K

    Conditional formatting: Format entire row based on single cell value and using defined names

    Hi all, I'm kinda new in VB/VBA and I was wondering if the following is possible: Currently I'm using a workbook, containing multiple sheets, to create a status overview. One of the sheet is used to list all open defects and contains information like unique ID, description, affected version...
  9. G

    Excel VBA, Variable Object Name

    Hi Folks, Hope someone out there will knwo the answer to this, i'm help referenced and googled out my head with this one. i wasnt to create a loop to change object properties in my userform, the object type is always the same, i.e. a textbox, but the name is variant, i.e. textbox1, textbox2...

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
Back
Top