-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
controlsarr
-
I
Still unable to locate the case of a invalid sort
Hi, Ive touched on this before but never solved it so now having a clear head im trying once again. I have a userform which once the fields are completed i press CommandButton1 which transfers the data to my worksheet & then sorts column A from A-Z so far this is ok. My problem is that column...- ipbr21054
- Thread
- .autofiltermode controlsarr dim end false
- Replies: 27
- Forum: Excel Questions
-
I
Format info from userform to worksheet
Hi, My working code is supplied below for you. Can you advise how i can format the info from when its entered into the cell. Could you advise how it would be for the format called GENERAL Private Sub CommandButton1_Click() Dim i As Integer Dim ControlsArr As Variant, ctrl As Variant...- ipbr21054
- Thread
- controlsarr dim end format info
- Replies: 2
- Forum: Excel Questions
-
I
Addition to existing working code
Hi, The code supplied below transfers the input data from my userform to my worksheet. Private Sub CommandButton1_Click() Dim i As Integer Dim ControlsArr As Variant, ctrl As Variant For i = 1 To 6 With Me.Controls("ComboBox" & i) If .ListIndex = -1 Then...- ipbr21054
- Thread
- code controlsarr dim end worksheet
- Replies: 7
- Forum: Excel Questions
