the file(test-db.xlsm) is text file because it has empty code. thank you very much.( with 1 macro)
Printable View
the file(test-db.xlsm) is text file because it has empty code. thank you very much.( with 1 macro)
Glad it worked. To attach a file the next time, write your text then ...
1. Click [Go Advanced] below and to the right
2. Click the 'Paperclip' icon
3. Click [Add Files]
4. Click [Choose File]
5. Browse to the file to upload
6. Select the file, click [Open]
7. Click [Upload] on the Add Files dialog
Attachment 29687Attachment 29689Attachment 29688
Some annoyances I find --
1. You can only add one file at a time, no multiselect
2. Some file types cannot be uploaded
3. There is a reasonable (?) limit on file size
4. You can [Insert Inline] like the screenshots above or [Done] to have them in the [Attached Files] area
Attachment 29690
1. I don't understand your comment
2. I don't understand your overall intent
Quote:
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
3. Go back and read Post #14
Quote:
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
4. Just save the attached XLSM and then double click it. Look at code in ThisWorkbook module, UserFOrm1, and Module1
Attachment 29694
@mtplmtpl. the file you uploaded is meaningless. Where is the file you talked about in your initial post? Did you look at the example (Demo.xlsm) the Paul_Hossler kindly provided for you?
I seriously doubt that you did for if you had done so you will have seen a perfectly good example of a workbook upon opening loading a Userform1 and only showing the Userform. On that Userform is a Command Button which when clicked "calls" the Sub Hello module which simply displays a message "Hello!!".
If you haven't do so by now I request that you pause here and do so by saving Paul's file to your system, locate the file by using File Explorer, Double click on the file Demo.xlsm and click on the Command Button that is embedded on the Userform. This example does everything you asked for. When you are ready to try to understand the structure of the workbook, select Developer section ( Alt F11 in Microsoft systems I believe). The workbook contains a Userform1 and three modules. If you click on THisworkbook you will find the 1st, click on Userform1 to find the second, Click on Module1 to find the third.
Attachment 29691
Click on Thisworkbook to find the 1st module. It is this module which upon the workbook opening, loads and shows the Userform1.
Attachment 29696
Click on UserForm1 to find the second module, in which the command button function calls the Sub Hello()
Attachment 29692
Click on Module 1 to find the 3 section of code, namely the Sub Hello()
Attachment 29693
Once you have done this you should now understand where to place your sections of code, how to construct them, and the reasoning behind the structure.
In your very first post you talked about having constructed a Userform and a macro. Unless you are prepared to upload the workbook upon which you are attempting to design your Userform, we are very limited in giving you precise assistance.
@AussieBear -- roger that
@mtplmtpl -- I tried to make sense of your second file - text-db - and guessed at some things that might give you the idea about how to structure your workbook since the other suggestions from myself, Aussiebear and other did not seem to take
Hopefully, you can relate better to test-db and see where things need to go. Save it somewhere you can find it and then double-click the XLSM file in Explorer
Other than that, I'm out of ideas
Dear admin and Paul. Everything works very good according to your recommendations. thank you very much and sorry