Search results for query: *

Hi, Who can help me with the following, I'm making my first program in excell VBA, Because I'm not familar with al the codes I made a procedure with if and then, This was a lot of work and now i've tried to run it the procedure is to big !!!!!!!!! You can imagin the words that came out of my...

Hi, Who can help me with the following, I'm making my first program in excell VBA, Because I'm not familar with al the codes I made a procedure with if and then, This was a lot of work and now i've tried to run it the procedure is to big !!!!!!!!! You can imagin the words that came out of my...

Hi, I've got the following code(only a part), Worksheets("test").Cells(15, 8).Value = Som("Worksheets("test").Cells(15, 8): Me.TextBox1.Text") What I want to do is, put the value of textbox1 in cell H15 BUT in this cell is already a number. Now I want a code...

Hi, I've got the following problem, when I chose in the calendar of my userform a date in november it doesn't work can somebody have look what is the problem. HELP I'm getting mad. Private Sub CommandButton3_Click() If Me.Calendar1.Day <= Day(&quot;301102&quot;) And Me.Calendar1.Day >=...

Hello can somebody help me with the following, I'm trying in a userform to get a difference in a date especially for the month, if in the calender the date is 1-11-02 then it has to right the information to the cell (H14 and i14) but if the date is in december then it has to write the info to 2...

Hello Rob, I've got the following, Private Sub CommandButton1_Click() ' ' Annuleerinvoerform1 Macro ' De macro is opgenomen op 25-11-2002 door Joep Spronck. ' ' UserForm1.Hide End Sub Private Sub CommandButton3_Click() Worksheets(&quot;Test&quot;).Cells(14, 8).Value =...

He Guys, I've got the following, Private Sub CommandButton3_Click() Worksheets(&quot;Test&quot;).Cells(14, 8).Value = Me.TextBox1.Text Sheets(&quot;test&quot;).Cells(14, 9) = Me.Calendar1.Day Unload Me End Sub and this working fine, If I now want to go to the specific worksheet...

Hi Guys, can somebody help me with the following I've checked the previous questions on the forum and also some books and the help menu but nothing so far, I hope you can help me, I've created a userform in this userform i've got a calender and a text box How can I get this information...

Hi, Can somebody help me with linking a range of cells out of my worksheet &quot;test&quot; to my listbox1 in my userform1. thx Joep

Rob, Maybe you can help me with the folowing, In my Userform I've got a calender insert now I want that If I choose a date in this calender that the information that has been chosen from the &quot;keuzelijst&quot; will inserted in a the worksheet corresponding to the month of this calender and...

Hi Guys this is working, I've renamed the file from userform1 to Budget that was the reason for the error. This was a great help!! Now I will start ( trying : ) ) with the macro's from the userform so I mean to assign from a choice list and text box the data to specific sheets in the excell...

Hi Guys , thank you for help, But if I use the following Sub naaruserform() ' ' jaaroverzicht Macro ' De macro is opgenomen op 25-11-2002 door Joep Spronck. ' ' UserForm1.Show End Sub I receive the message &quot;object vereist&quot; What I want to do is the following, I want that when...

Hi, I'm creating a new project and I want to activate a userform that I've created in Visual Basic but how can I get this userform activated when I use a button in Excell. can somebody hel me. Many thanks Joep