|
VBA went to 6.5 and is still in use in Office 2007, maybe even 2010 - I don't have a copy to check.
If you mention Visual Basic (alone) or VB6, everyone will assume it's the full Visual Studio 6.0 version. If you're working in Office, you have to say VBA, otherwise, everyone will think you're doing Office interop from a VB6 app.
|
|
|
|
|
Not relevant to this post just to let you know: VBA version in Office 10 is 7.0.1590 and Form3 is 14.0.4747.100.
Tosch
|
|
|
|
|
Right, got it. So the code I've been consulting for VB6 is not going to work for VBA. Can you suggest a drag/drop method for a CommandButton that will work in VBA?
|
|
|
|
|
Then buttons don't work the same way in Office as they do in the "real world". I don't think you're going to be able to drag the button itself, but you can drag a container that the button is in, such as a user form.
|
|
|
|
|
That's a good idea. Any suggestions on code that makes a user form draggable in VBA?
|
|
|
|
|
You don't need any code. A UserForm is already draggable.
|
|
|
|
|
That will work. The only thing is I'd like to hide the top blue border as well as the 'X' button. Can you suggest methods that will hide both?
|
|
|
|
|
You can't get rid of the title bar without stopping the ability to drag the form. You'd have to write new code to put back in the ability to drag the form, but there's a problem. If the user tries to drag the form around and clicks on one of the controls on it, your code will never know that the user is trying to drag.
As for the close box, you can add code to cancel closing the form, but you can't remove it.
|
|
|
|
|
Thank you, Dave, this has been a huge help. I'm going to go with a user form and put the button control in it. This will appear on all sheets. The control is a bit large with the top bar and 'X' but it works fine functionally. Thanks again.
|
|
|
|
|
please see this
http://wastuae.com/uae/adv.aspx?id=470299
|
|
|
|
|
Hi,
I have a form with TabControl object at which there are 5 tabpages
What I want to do is that when user click the tab, the new tabpage is showing on form, at this time I want to show some message use msgbox "".
Now I use TabControl1_Selected event, the message is always shown before the actually tabpage is displayed, I want the message is shown after tabpage is displayed.
How can I do it?
Thanks!
|
|
|
|
|
The Selected event may be the wrong one. IMO you should use the SelectedIndexChanged event, and wire it after the Form is completely ready, i.e. in its Shown handler.
|
|
|
|
|
Thanks! SelectedIndexChanged event works if the tabpage is not the first one.
If the tabpage is the first page (index = 0), the message still cannot be shown.
|
|
|
|
|
You might also try handling the TabPage.Enter event.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks for reply!
TabPage.Enter event doesn't work.
|
|
|
|
|
Hi all,
I am using a list view in my project to display some data.
The listview has over 5000 element to display.but
when i run my program through debug mode then it gives the following error
"The CLR has been unable to transition from COM context 0x1a1010 to COM context 0x1a1180 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping"
but when i run the exe then it is working fine.
can any body give me any clue,why it is happening ?
|
|
|
|
|
how are you loading the data?
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
souravghosh18 wrote: can any body give me any clue,why it is happening ?
Are you doing that processing on the UI-thread? Have you considered moving it to a backgroundworker?
I are Troll 
|
|
|
|
|
Hi,
Can any one help me out in regards to Calling WebService from VB6 environment ?
Thanks in advanced !! 
|
|
|
|
|
Documented thousands of times. All it takes is a small effort on your part to actually do some research. Here, let me help: Click Me[^].
|
|
|
|
|
Heya guys I work in a PC repair shop and we deal with a lot of customers that have alot of infections on their PC. I have been trying to create and application that will kill explorer but it doesnt not convince it to stay dead it will only restart, I understand microsoft made it this way to prevent any malicious activity dealt to the computer. My6 application normally scans a specified directory where most ransomware or desktop hijacks take place such as %USERPROFILE.\Local Settings\Application Data\<cryptic infection="" name="">, I know most of the time it will still execute even if explorer is not loaded 80% of the time it does not happen, But my Goal is to stop the explorer.exe from loading, I dont want to take the route of removing HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogo and changing its value, it is still a thought but not very professional IMO.
just from this snipper all i have is:
Imports System.Diagnostics.Process
Dim Proc() As Process = System.Diagnostics.Process.GetProcessesByName("explorer")
Dim ProcSeek As Process
For Each ProcSeek In Proc
ProcSeek.Kill()
Next
Any help to maybe would be appreciated. =)
|
|
|
|
|
Why do you need to keep explorer dead?
You should always perform really deep cleans while in safe mode. this prevents all the unnecessary apps and dlls from firing up, and helps to break the recursive loops that many malicious software uses. i.e. dll spawing clones and monitoring each other for being removed etc.
Dave
Find Me On: Web| Facebook| Twitter| LinkedIn
CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
|
|
|
|
|
Screw stopping Explorer. Take off, nuke the machine from orbit. It's the only way to be sure.
Seriously, blow away the machine and rebuild from scratch. It's the only sure-fire way to get 'em all.
Then stay away from those "sites".
|
|
|
|
|
When I kill explorer.exe from task manager, it dosen't restart? The only time I have seen explorer.exe restart it's self is when it crashes
See if you can crack this: fb29a481781fe9b3fb8de57cda45fbef
The unofficial awesome history of Code Project's Bob!
"People demand freedom of speech to make up for the freedom of thought which they avoid."
|
|
|
|
|
explorer will not restart if killed from task manager, uts just how microsoft created it, but if killed from your ide's app it will restart. but I understand what your saying bout performing scans in safe mode, cause services that are required to keep windows stable without the unecessary programs are the best to run scans with windows at minimal resources. I was just hoping to create an app to avooid the delay when booting into safe mode. I am fmailair with explorer and I know people ask questions like "why on earth do you want to kill explorer?" I work in a repair shop I know what the outcome is heh, I just thought there was always a faster route, but sorry for the ruckus =)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
