Need an authentic option to inform the one you love that you just love him\/her this Valentine’s Day? Why not e-mail them a workbook with a pop-up message! When your sweetheart opens the workbook, they are going to see a message telling them your true emotions.<\/p>\n
Here is the way it works:<\/p>\n
1) Create an Excel workbook.<\/p>\n
2) Press ALT + F11 to enter the Visible Primary code editor.<\/p>\n
three) On the left-hand facet of the code editor you will see Venture Explorer (if you cannot see this, press CTRL + R to open it).<\/p>\n
four) It is best to see the workbook title on the left, with Sheet1<\/strong>, Sheet2<\/strong>, Sheet3 <\/strong>\u8fd8\u6709 ThisWorkbook <\/strong>beneath it. Double-click on ThisWorkbook <\/strong>to connect code to one of many occasion’s within the workbook’s life (on this case, what occurs whenever you open it).<\/p>\n 5) You see two drop-down arrows on the high of the code window. Click on on the left one (which at present says Basic<\/strong>) and select Workbook <\/strong>as an alternative (the one different doable possibility).<\/p>\n 6) Now you can see the next code:<\/p>\n Non-public Sub Workbook_Open()<\/em><\/p>\n Finish Sub<\/em><\/p>\n Between these two traces of code, sort in a command to show a message. One thing like this is able to do:<\/p>\n MsgBox “I really like you!”<\/em><\/p>\n For a barely extra spectacular system, ask the one you love whether or not they’ll be your Valentine:<\/p>\n Non-public Sub Workbook_Open()<\/em> Reply = MsgBox(“Will you be my Valentine?”, vbQuestion + vbYesNo, “Valentine’s Day”)<\/p>\n If Reply = vbYes Then<\/p>\n MsgBox “Then I will be yours!”, vbExclamation + vbOKOnly<\/p>\n Else<\/p>\n MsgBox “Oh…”, vbExclamation + vbOKOnly<\/p>\n Finish If<\/p>\n Finish Sub<\/em><\/p>\n Good luck!<\/p>\n Need an authentic option to inform the one you love that you just love him\/her this Valentine’s Day? Why not e-mail them a workbook with a pop-up message! When your sweetheart opens the workbook, they are going to see a message telling them your true emotions. Here is the way it works: 1) Create an […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[15],"tags":[200,595],"builders":[],"industry":[],"platform":[],"class_list":["post-6162","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-wordpress","tag-wordpress-tutorial"],"acf":[],"yoast_head":"\n
\n
Dim Reply As Lengthy<\/p>\n