Search results for query: *

Is it possible to put some text at the top of the body in a fetched template via VBA code? The main body of the template is sent to different users with a text at the top of the body that differs (a text string that have a number of variables from textboxes in the user form. I hope that you...

I’ve made a program in Excel that sends e-mail in Outlook (2010) after the user has put same information in a user form. This Is not a problem but I get this annoying message – “another program Is trying to send an e-mail etc.” Allow – Deny – Help. I’ve searched for help but I haven’t found...

I’ve searched the web and found the following code to send a draft and the code works fine. But with one exception – the draft is sent and removed from the drafts folder. Is it possible to modify the code so the draft is sent and kept for recycling? The content of the draft is sent several times...

The code for recipients and attachments is finished but how to open a previously saved mail I can’t figure out. I’ve looked around and have not found anything useful. Thanks beforehand Christer

Is it possible to use the mxmask32.ocx located in windows\system32 on a user form? If it is, how can I do it? Happy weekend to you all Mollethewizard

I suppose this is really simple, but, how can I read data from an ini-file to a variable in Excel? The ini-file is situated in C:\USER and is named User.ini. It has a section [Employee] with Name=Sven Svensson Let’s say I would like to read Name and put it in a variable X. In Word I use...

This maybe very simple – but anyway – I’ve got a workbook with a modeless user form with a button that closes this particular workbook. Code goes like this: Application.ActiveWorkbook.Close Savechanges:=False That’s all right providing the workbook is activated. Is there a simple way to assign...

I’ve got a user form with several text boxes in it that the user puts Swedish currency values in like this – 123,55 – as you probably know we use commas as decimal sign in Sweden. The values are passed to a sheet and then if something is wrong and the user wishes to alter the “input” the values...

Probably this is very simple but I haven’t found the solution. Is there a way to pass a workbook name to a variable? It would be most helpful if the variable could be used in different modules within a project. The variable is to be used like “name.activate” , name.close savechanges = no etc...

Is there a way to navigate between Option buttons in a user form by hitting the Enter-key? It’s annoying when you use the Enter-key to move to the next control and then suddenly have to hit the Tab-key to move along. Greetings from a grey and cold Sweden.

Hello Is there a way to change the mouse icon to a hand when the user moves the cursor to the OK button in a user form? Is the “function” available in VBA? And how do I accomplish the change? Greetings Mollethewizard

I have got a major problem whit a user form. The form has 4 textboxes a command button and a number of labels. When the form is initialized the 4th textbox is set - visible = False. If the textbox preceding has a value of 13 then the textbox is visible from code in the exit-event of the third...

Hello all gurus out there! Can anyone tell me what is the most efficient regarding speed and size – one module with all subs in it or many modules with one or a few subs? Somewhere along the line I’ve heard that speed increases when VBA doesn’t need to resolve dots. All the subs that I use...

Good morning! Is there a way to close/hide a user form by using one of the F-keys? Any code suggestions? Greetings Christer

I’ve got a textbox in a user form that are limited in max lenght to 200 signs. I would like to put a label in the form that informs the user form how many signs there are left when he enters text in the textbox. How can I accomplish that? Christer

Got a user form with textboxes for name, address, zip code, city and an OK-button. Code written for the txtZipcode exit event that calls a subroutine with a number of cases. The idea is that if the zipcode corresponds with a case then txtCity = the case. Hope that you follow this far. What I...

I’ve got a user form with a TextBox that I would the user to either leave empty or state a value according to the given mask. How can I increase the code below so both criteria’s will be accepted? Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) If Not TextBox1.Text Like...

I’ve got a user form with textboxes where the users should put in amounts. In Sweden we divide the amounts in groups of 3. For example 1000 we write 1 000 and 78500 should be written 78 500. I’ve managed to write code that takes care of the spaces between the groups when the user exits the...

Is there a simple way to make all textboxes, labels and option buttons in a user form not visible when the form initializes? I know that I can say – me.Textbox1.Visible = False – but if you’ve got a bunch it takes quite a bit of coding. Is it possible by using For Each? Later in the initialize...

I would like to run Excel from a Word macro. I’ve managed to open Excel and a worksheet but I can’t figure out how to write the code that transfers the values of some textboxes from a user form in Word to the appropriate cells in Excel. Enclose the code so far. Can anyone help? Sub Excel()...