Posts by workfrustration

Dont mind me. Little too early on a friday to be thinking.

Application.Run "Personal.xls!Macro"

Sry about wasting your time.

How does one start a macro from another workbook? More specifically I want to start a macro in my Personal Macro Workbook ("Personal.xls").

Is there any way to activate the wheel mouse feature in ComboBoxes?

Thanks

This doesnt seem to work. I put many different values in for both but each time the userform loads in the same position.

I realize that there is not direct way to minize a macro. I have a button and I want to basically:

Private Sub Hide_Click()
userformhidden.show vbModeless ' For this like I have a question ?
userformmain.hide
End Sub
Private Sub UnHide_Click()
userformhidden.hide
userformmain.show vbModeless
End Sub

When I show userformhidden is there a way to perhaps place this in the excel toolbar or just designate a place for this small userform to be shown?

Thanks
WorkFrustration

Programing a Minimize Button

I realize that there is not direct way to minize a macro. I have a button and I want to basically:

Private Sub Hide_Click()
userformhidden.show vbModeless ' For this like I have a question ?
userformmain.hide
End Sub
Private Sub UnHide_Click()
userformhidden.hide
userformmain.show vbModeless
End Sub

When I show userformhidden is there a way to perhaps place this in the excel toolbar or just designate a place for this small userform to be shown?

Thanks
WorkFrustration

wow that works awesome Thanks guys

Is there any way to set up a user form so that you do not have to close it everytime you want to change something in excel? When I run my userform from a macro:

Public Sub Run()
userform.show
End Sub

is there any way to set it up so that excel can be changed while my userform is being shown? It seems that excel is locked up when my userform is running. Any suggestions?

Thanx
Workfrustration

Question:

I have finished my master program and it has two files that I want others to use. I am trying to work out a fool proof macro that will be a way for someone who has never see visual basic before to get these files into vba without messing it up. I would like the user to have the option between placing my programs in their Personal Macros or an excel file of their Choice. Anyone have any suggestions? The two files are as follows:

Highlight_v1_Config.bas //the userform file
Highlight_v1.bas //the module file

Thanx,
Workfrustration

Thanks, that should help

Question:

How can I set the First Row in a Range equal to a variable and the same with First Column?

Thanx
Workfrustration

Problem:

I want to be able to save some ComboBoxes and TextBox hold their values. For example I want to run my program and then have a button that says save defaults. All the values that are currently in the ComboBoxes and TextBoxes will appear then next time the program is started.

Any suggestions or paths to lead me on to figure this out would be appreciated.

Thanks

ActiveWindow.ActiveSheet.AutoFilterMode = True or False

Got it

Problem:

I need to know if the AutoFilter is On or Off. I have tried:

If Application.ActiveWindow.ActiveSheet.AutoFilter.Range.Rows.Count = 0 ...

But I get error as follows:

Run-time error '438'
Object doesn't support this property or method

Thanks

Yes that works, thx i guess im not all with it today

My problem:

I am using xlSolid to "Clear" patterns yet this does not work and leaves my cells white. What value do I set Interior.Pattern to for it to clear?

:thanx:
WorkFrustration

First off, I have learned C++ but never seen Visual Basic before until a few dayz ago. I got the hang of it but w/ no book to study all I have are the help files and the internet. I started with a complete program that worked fine. Then I realized that the only way to configure it was manually through the VB code. Then I started my journey on creating a UserForm. I have my UserForm done and set up. The only thing that is not working is the OK/Run button. I set up all my vaiables that are required to run and I wanted to configure, in my module seperate from my original program as Public. Then under my Ok/Run button I defined all these variables (eg Module.Variabe = whatever user enters). This step works as I have a message box pop up w/ all the variables to check them set before trying to go back to original program. I have also set all the original vaiables in my original program the same way (eg Module.Variable) thinking that this would solve my problem, but I get errors because my Public Variables are not defined at compile. Should I just define these Public variables or something else ??? In my Ok/Run button I tried a varriety of things;

Modules.Application.Run (Highlight.Highlight_v1) 'Highlight is my Module Name; Highlight_v1 is my macro name

This game me error of not proper function or something like that then...

I also tried setting up my macro as a function w/ all my public variables in that and then putting them all in like this:

//In Macro:
Public Sub Highlight_v1(ByVal FirstColor As Integer, ByVal SecndColor As Integer, ByVal ColorPattern1 As Integer, ByVal ColorPattern2 As Integer, ByVal ExcludeColor As Integer, ByVal ExcludeColor2 As Integer, ByVal StartRow As Integer, ByVal StartCol As Integer, ByVal ComparisonCol As Integer, ByVal MaxCols As Integer, ByRef MaxRows As Range)
//tried in place of "Sub" -> "Function"

//In UserForm:
Modules.Application.Run (Highlight.Highlight_v1, Highlight.FirstColor, Highlight.SecndColor, Highlight.ColorPattern1, Highlight.ColorPattern2, Highlight.ExcludeColor, Highlight.ExcludeColor2, Highlight.StartRow, Highlight.StartCol, Highlight.ComparisonCol, Highlight.MaxCols, Highlight.MaxCols) //These are all my variable I want to configure

Any help or advice on do's or don't would be greately appreciated!

:thanx:
WorkFrustration