procedure

I have a module with a procedure called Upload() and a UserForm where the user should insert both username and password and click the command button. I want to control the UserForm through the procedure Upload() instead of using cmdUpload_Click and such. Something like Public Sub Upload()...

I'm relatively new to excel and have been having an issue with some vba in this model i'm working on.... Essentially I want to run 3 goalseeks on the same dynamic variable (L63) and return the minimum value goalseek finds. The following are the procedures for each goalseek: <!--[if gte mso...

<TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD class=smalltxt vAlign=top>Hi The procedure called from SQL database and would like to run through Ms Access In Ms Access I already running Queries using following function The above function execute all the SQLs from the...

Hello GANG! I have 3 modules I am trying to merge into 1...they are: Sub WriteOffs() ' ' WriteOffs Macro ' maniplute Imported Oracle Data for write-offs ' ' Columns("J:L").Select Selection.Delete Shift:=xlToLeft...

Hi all, I want to load a userform in the middle of a procedure and only continue the procedure after the userform has been closed. Is that possible? excel 2003 Many thanks, Shie Boon

I need to pass the value of a variable from one procedure to another without running the entire called procedure Private Sub openReport(ByVal strProductFile as string) MsgBox "Open previous week's report.", vbOKOnly + vbExclamation, "Open" Application.Dialogs(xlDialogOpen).Show...

Hi guys, is it possible to call a Worksheet's activate event from a procedure? Or maybe, refresh a worksheet from a procedure. i'm using excel 2003. Thanks Shie Boon

Is it possible to call a label in a procedure? In other words, I want to run part of the code in a procedure rather than running the entire procedure. Call LabelA Public sub ProcA do something... LabelA: do something with LabelA.. End sub

Hi. I want to write a Sub. I want to Call the Sub from a UserForm Module (CommandButton_Cilck Event). I want to Call the Sub from a Worksheet Module (Selection_Change Event). What Type of Module must the Sub be in? What Type of Sub should it be? (Presumably Public) Currently, my Sub is a...

Hi all, From within the code in an Add-In I am trying to call a procedure from the ActiveWorkbook. So my code looks somewhat like: Sub MyProcedureInAddin() 'My code here... Run ActiveWorkbook.Name & "!SomeProcedure" 'My code continues... End Sub This works fine if...

Finally got all the bits and pieces working together (in I'm sure the dirtiest way), but it seemed to be doing what I wanted, then when I tried to expand it...fail. Rundown: I have a workbook where I select checkboxes (cells) on the first tab, and then a macro copies the corresponding column...