run macros from windows

[mtplmtpl]

I am working with userform for the first time. I made a macro text3 (there is this code in module1), created a form userform1, with one click button, I can't run my macros text3 from this form. By clicking on the run button, I automatically get to a module. There I see two sub... end sub. It is necessary to write code inside of the module. I don't know what exactly. Similarly with another form, it is necessary to reflect the message from msgbox on it. Help

[Aussiebear]

Can you post your workbook so we can see what you currently have?

[SamT]

The Code that a CommandButtopn runs should be in the Commandbutton_Click() Sub, Unless you need it to run with Other Controls. It should only be ina Module if it will be used outside the UserForm
CBut Code

Sub CButton1_Click()
   Code from text3 Here
End Sub

Multi Form Control Code

Sub CButton1_Click()
   Text3
End Sub

'UserFormCode:
Sub text3()
   blahblah
End Sub

MultiUse Code

'UserForm Code
Sub CButton1_Click()
Module1.text3
End Sub

[mtplmtpl]

Thank very much I' try your recommendations. Thank you again

The Code that a CommandButtopn runs should be in the Commandbutton_Click() Sub, Unless you need it to run with Other Controls. It should only be ina Module if it will be used outside the UserForm
CBut Code

Sub CButton1_Click()
   Code from text3 Here
End Sub

Multi Form Control Code

Sub CButton1_Click()
   Text3
End Sub

'UserFormCode:
Sub text3()
   blahblah
End Sub

MultiUse Code

'UserForm Code
Sub CButton1_Click()
Module1.text3
End Sub

[mtplmtpl]

Thank you very much

Can you post your workbook so we can see what you currently have?

[mtplmtpl]

Thank very much I' try to use your recommendations. Thank you again

[mtplmtpl]

Sorry. I think yesterday I sent you this message, but to the wrong address. That's why I'm repeating it today. I keep trying to make code to run my program code from Windows. My task is that when I click on the address of my file from Windows (in Windows Explorer), then Excel should open my user form with one click. From it I will run my program. I have tried your suggestions but have not been successful. Because of my main problem - I'm a beginner. In this situation, is it possible for you to send me a fragment of the program, where the code recommended by you would already be used. Excuse me please.

[SamT]

In Windows, One click means "Select". Two clicks means "Open" or "Run". Except sometimes.

[mtplmtpl]

Certainly. When I double click it opens my database. I need to open the place where my userform is displayed . if it is possible. thank you and sorry.

[mtplmtpl]

for-d.b-excel.jpgform-excel.jpg
When i make twice click on the address of my file in Windows Explorer then i see left picture but i'd like to get right picture.

[Aussiebear]

Talk about running around in a circle... From what I understand you ar requiring a Userform to become visible upon opening of a particular workbook.

Private Sub Workbook_Open()
Userform1.Show     <- change to correct name of Userform
End Sub

[mtplmtpl]

but how to run from windows explorer? after than I will use your code. exactly- user clicks on the address of file in windows and he see form1 on his computer. thank you and sorry

[Aussiebear]

I don't have a Microsoft system, but from reading your previous comments and those of SamT, once you have the file address in Explorer did you try the double click function that you both talked about?

[Paul_Hossler]

Cookbook approach

1. Save the attachment to your Documents folder

2. Change to your Documents folder and find the file

3. Double click the file

Capture.JPG

4. You'll still have to Enable Macros

5. Examine code in ThisWorkbook, UserForm1, and Module1

[mtplmtpl]

for-d.b-excel.jpgform-excel.jpg
When i make twice click on the address of my file in Windows Explorer then i see left picture but i'd like to get right picture.

Sam.T I take my hat off to your professionalism and patience to help beginners. Thank you

[Aussiebear]

@mtplmtpl Did you look you even look at the example provided by Paul_Hossler? Paul clearly shows how to open a file from Windows Explorer and have that file upon opening, show the userform. SamT has given you the basics for doing the same thing but you don't seem willing to do the fundamentals as indicated. You posted your response some 7 hours after getting Paul_Hosslers reply.... which suggests to me that you didn't even evaluate his suggestion. Why should people even want to assist you?

[mtplmtpl]

Thank you. It works very well. it opens workbook. I'd like to open my macro. is it possible ?

[Aussiebear]

Upload your file so we can see what you currently have.

[mtplmtpl]

I am very grateful to those who help me. wrote about this many times. SamT and Paul Hossler. I spend a lot of time to understand the answer. Now Sorry, I can't because I can't find the icon in the forum (I found how to download a photo and a picture, but not a file). excuse me. i try

[Aussiebear]

In your next reply, click on Go Advanced/ Manage Attachments and choose your file. Upload from there bearing mind there are size limits to certain types of files