# Search:

Type: Posts; User: Juan Pablo González; Keyword(s):

Page 1 of 6 1

1. ## Thread: How can one resize the task list in a taskFormGroup in the Backstage?

by Juan Pablo González
Replies
13
Views
1,320

### Re: How can one resize the task list in a taskFormGroup in the Backstage?

Greg,

I found two properties that might help: FirstColumnMaxWidth and FirstColumnMinWidth. Not sure if they will do, but it's worth a try. Found here and here
2. ## Thread: Can I make this equation easier?

by Juan Pablo González
Replies
5
Views
242

### Re: Can I make this equation easier?

You were close, try this

=IF(OR(ISNUMBER(SEARCH({"715","717","718","94"},\$G1)))," -1"," ")

but enter it with Ctrl + Shift + Enter, not just Enter.
3. ## Thread: Lock/Exclude in Binary Constraint

by Juan Pablo González
Replies
7
Views
603

### Re: Lock/Exclude in Binary Constraint

If I understand you correctly, in the "Output" column, which starts in C2, I put the following formula:

=E2*IF(D2="L",1,IF(D2="X",0,A2))

Then in C9 I put the total of the column

...
4. ## Thread: Lock/Exclude in Binary Constraint

by Juan Pablo González
Replies
7
Views
603

### Re: Lock/Exclude in Binary Constraint

Yes, if you set A1 to be a binary constraint, it will be used by Solver, and if your model depends on B1, then the formulas will autocalculate and Solver will see that.
5. ## Thread: Lock/Exclude in Binary Constraint

by Juan Pablo González
Replies
7
Views
603

### Re: Lock/Exclude in Binary Constraint

From here you can see that a binary constraint is one that can either take a 1 or a 0. So, you can keep your L / X, but use them in a separate cell. In other words, you need two cells: One, say A1,...
6. ## Thread: VBA: How to store a reference to an Object type within the Object type

by Juan Pablo González
Replies
13
Views
796

### Re: VBA: How to store a reference to an Object type within the Object type

Hey Zack... it's all Tracy's fault. You can blame it on her.
7. ## Thread: VBA: How to store a reference to an Object type within the Object type

by Juan Pablo González
Replies
13
Views
796

### Re: VBA: How to store a reference to an Object type within the Object type

There must be something I'm missing, because I don't see how you get a stack overflow error. Here's what I coded

CPerson:

Option Explicit

Private m_mother As CPerson
Private m_father As...
8. ## Thread: Understanding Classes

by Juan Pablo González
Replies
2
Views
436

### Re: Understanding Classes

Here's something that might help you.

https://groups.google.com/forum/?hl=en&fromgroups#!topic/microsoft.public.vb.enterprise/lmDvTaTpKQQ
9. ## Thread: Transfer Userform label value to Sheet as Currency

by Juan Pablo González
Replies
3
Views
983

### Re: Transfer Userform label value to Sheet as Currency

Not sure if you're using a formula or entering the text in the cell directly. If the first, you need to use the TEXT() worksheet function to format the value (34.44) as currency. If you're doing it...
10. ## Thread: Symbols for Macro Buttons - Ribbon Customization

by Juan Pablo González
Replies
1
Views
902

### Re: Symbols for Macro Buttons - Ribbon Customization

Not that I know of. You can customize the ribbon with Ribbon XML, which allows you to use custom images, but there's no "icon editor" as there was before.
11. ## Thread: Can CommandBars and Ribbon code co-exist?

by Juan Pablo González
Replies
2
Views
402

### Re: Can CommandBars and Ribbon code co-exist?

For the Ribbon, you need an XLSM or XLAM file. If you can get your 2003 users to install the addin that allows them to open those files, then you can have one version, if not, then no, a separate...
12. ## Thread: Query Assistance

by Juan Pablo González
Replies
7
Views
717

### Re: Query Assistance

Something like this maybe?

SELECT [Location], X, COUNT(X) AS CountOfX
FROM TempQuery
WHERE [Region] = "Madagascar" AND X IN ("N", "Y")
GROUP BY [Location], X
13. ## Thread: VBA: SaveSetting limitation?

by Juan Pablo González
Replies
2
Views
941

### Re: VBA: SaveSetting limitation?

http://support.microsoft.com/kb/256986
14. ## Thread: Pivot Table Change Event in VBA

by Juan Pablo González
Replies
2
Views
8,547

### Re: Pivot Table Change Event in VBA

You can try some of the files that are available here:

http://www.contextures.com/excelfiles.html#Pivot

For example, PT0021 or PT0025.
15. ## Thread: XL97 to XL2010 help on VLookup and Match

by Juan Pablo González
Replies
2
Views
233

### Re: XL97 to XL2010 help on VLookup and Match

That "D5" in the MATCH formula is invalid. Not sure what Excel 2000 is doing, but it can only be a -1, a 0 (most likely what you need) or a 1.
16. ## Thread: Folder Search Location Using VB

by Juan Pablo González
Replies
2
Views
282

### Re: Folder Search Location Using VB

You can use ChDir to change the current active directory, which will be used when the GetOpenFileName is executed.
17. ## Thread: Parse JSON with Excel VBA

by Juan Pablo González
Replies
34
Views
177,683

### Re: Parse JSON with Excel VBA

You need to import the "JSON.bas", "cJSONScript.cls" and "cStringBuilder.cls" to your project.

Go to Tools | References and add a reference to the "Microsoft Scripting Runtime" library and to the...
18. ## Thread: Parse JSON with Excel VBA

by Juan Pablo González
Replies
34
Views
177,683

### Re: Parse JSON with Excel VBA

I'm using this:

http://www.ediy.co.nz/vbjson-json-parser-library-in-vb6-xidc55680.html

And has been working great.
19. ## Thread: strange IE history behaviour

by Juan Pablo González
Replies
4
Views
1,123

### Re: strange IE history behaviour

I never use IE, so I had it easy to check... I even cleared the history before checking. And no, I didn't get it.
20. ## Thread: How can I force a line break in a single cell?

by Juan Pablo González
Replies
2
Views
258

### Re: How can I force a line break in a single cell?

You can use

=A1&CHAR(10)&B1

but you do need to enable WordWrap.
21. ## Thread: Linking Outlook to Excel

by Juan Pablo González
Replies
2
Views
2,087

### Re: Linking Outlook to Excel

You need to add the reference to Microsoft Outlook using Tools | References...
22. ## Thread: How to change row color based on value of 1 cell

by Juan Pablo González
Replies
2
Views
491

### Re: How to change row color based on value of 1 cell

You can use Conditional Format for that, something along these lines:

http://www.bettersolutions.com/excel/EPX299/YR217210552.htm
23. ## Thread: Where do I find MrExcel Icon ??

by Juan Pablo González
Replies
8
Views
634

### Re: Where do I find MrExcel Icon ??

www.mrexcel.com/favicon.ico

That's what's used for the favorites. Not sure why Win7 doesn't use it anymore.
24. ## Thread: Trigger Event

by Juan Pablo González
Replies
3
Views
248

### Re: Trigger Event

Unfortunately, no.
25. ## Thread: How to ignore auto_open() when Workbooks.Open

by Juan Pablo González
Replies
2
Views
1,181

### Re: How to ignore auto_open() when Workbooks.Open

Actually, the Auto_Open doesn't run automatically when you open a workbook through VBA. Only the Workbook_Open() event fires.

If that's what you are using, then put

Application.EnableEvents =...
Results 1 to 25 of 150
Page 1 of 6 1