Search:

Hey,
I have a VB Application that creates an instance of an excel.application. The application then enters data in the excel sheet, just like normal. The thing that is tricky is i need to add code...

It's the right handle, the window reacts, it just doesn't pop up. I think i need to use SetWindowPos but i'm not sure how to set the flags, or if there is a better procedure for doing that.

I'm developing in VB6

Hey, i know there have been a lot of posts on this topic but i can't seem to find the answer to this question. I have an excel spreadsheet with cells full of visio shapes. When a double click is made...

Hey, i know there have been a lot of posts on this topic but i can't seem to find the answer to this question. I have an excel spreadsheet with cells full of visio shapes. When a double click is...

You need to put quotes ("8/30/2005") around the date...rigtht now you are asking if the date is equal to 8 divided by 30 divided by 2005 :)
It should work fine i just tested it :)

Hey, I have a custom visio tool bar and i have created a custom .ico file that i want displayed on it
the ToolBarItem class has a .IconFileName method that supports a string file path and loads the...

Moeur you're amazing :) it worked like a charm, i can't believe i didn't think of using a quick little timer. Thanks so much for your help!

Actually my last post is a little misleading. Clicking on the combo box at all causes teh focus to be pushed from the form to the box, causing the form to unload...so that doesnt seem to be the...

For some reason the SendMessage call causes the lost focus on the form to be called and and therefore unloads the form instantly :(

Clicking off the form doesn't fire the lost focus event on the combo box. Maybe it would be helpful to point out that the form is being loaded by visio, not another form
the deactivate event for...

Hey,
I have a form that is only a combo box, and when it is loaded it appears right next to the mouse and i use a send message event to drop down the list. Everything works fine, except if the user...

the reason DoCmd works in a VBA instance is because, as i understand it, in vba you're essentially in a With block whose variable is the application
so in VBA when you do something like DoCmd.Close...

regardless of where the msg box is in sequence, the code is all being fired from the click event which does not allow for unloading.
I tried to use DoCmd.Close, but on compile it said "variable not...

Hey,
I have a form that has a drop down list. I want the form to unload when a user makes a selection, instead of having them have to hit a command button. I tried to do it from the click event,...

Harsh, i think i know what you are asking...
couldn't you do this:

sString = txtBox.Text
if UCase(sString) <> txtBox.Text then
MsgBox "You may not enter lower case letters"
end if

I tried it in that same class and it still didnt' work, i don'[t think that is the problem

Ok here is the full deal
I have 2 class modules interacting here, one is to set up the command bar, the other is to handle the events. This is the code from the set up module:

Private cbrCmdBar...

Ok, this is what i've been trying:
I set up a method in my event handler class to sync the combo box, it looks like this

Public Sub SyncComboNav(box As Office.CommandBarComboBox)
Set...

ok, i am not getting it to work
this is my code in the setup class

Set cBarCombo = cbrCmdBar.Controls.Add(msoControlDropdown)
With cBarCombo
.Tag = "Navigate"
.Enabled...

Does the "MyEventSub" have to be in the same module as the place the command bar is created...if i want to you pass in paramteres can I pass in "MyEventSub(args)" ?

it must be the .OnAction event...I don't have it implemented now, what should i set it as?

That example pertains to Control Buttons (msoControlButton). I am currently using those and they are working fine
its the CommandBarComboBox that is giving me problem this problem

Here is an MSDN example of exactly what i want to do, but the code simply doesn't work, the event does not get fired
...

Microsoft Visio 2003

The CommandBarComboBox only has a change event, it is allegedly fired when someone makes a selection...alteast this is my understanding (and there is only 1 event selectable for it in visual studio)

I like it a lot! Any flakieness can probably be blamed on the fact that i'm writing for it in VB6 and not .Net (this is not by choice, believe me). I run into problems sometimes because clients are...

I'm trying to add a CommandBarComboBox to a custom command bar, and the command bar adds and populates fine, however i can't get it to fire its change event



'cbrCmdBar is my command bar...

2003

I actually am working in Visio and VB6...and I found the solution, it's interesting. Apparently the .Picture and .Mask properties throw errors if encountered during Debug mode...i compiled my dll...

Hey, i'm trying to load a custom icon for from a .res file and place it on a command bar button. I found some really straight example code, but for some reason it errors.
here is the example code:...

Hey, this is almost more of an excel question then a VBA question...but i'll have to do through code. I need a way to disable the linear prediction on auto fill without disabling auto fill itself. ...

Well i figured it out, if anyone is interested, here was the solution i came up with



'get the visio window rectangle
'get the visio window rectangle
Dim left As Long, top As...

How do i find the width and height of the Visio window?

Hey, I'm really sorry for the double post, but no one was even looking at this over in the VBA Forum, hope you can forgive me.

I think more information would help:

Hello. I have a routine for...

Hello. I have a routine for opening child forms from Visio. This is how I'm doing it:
frm is my form, and oVisio is my visio application

SetParent(frm.hWnd,oVisio.Window.WindowHandle32)...

The form isn't being opened from another form, its being opened from a visio toolbar
Maybe thats where things are getting messed up

This seems like it would be simple, but nothing seem to be working. If my app. isn't running maximized and a user opens a form, i want the form to be centered to the app, not the whole screen. I...

There can be up to a few hundred entries in the combos. The freeze thing might work, but it still may be too slow. Thanks for the advice

Hey, I have an array of 6 combo boxes. I need to ensure that user cannot enter any duplicate values into the combos. For instance, if the combo boxes have the values "string 1" ; "string 2" ; and...