define

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

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

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

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?

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

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

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!

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

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