-
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.
selects
-
stop error with VBA combobox
Hi All and thanks in advance for your help and wisdom I am currently using the following code to change a label on a userform Private Sub Combobox2_Change() Dim rw As Long rw = Me.ComboBox2.ListIndex + 1 Me.Label23.Caption = Sheets("Data").Range("D" & rw).Value End Sub It...- neilp
- Thread
- code error point selects stop
- Replies: 3
- Forum: Excel Questions
-
K
Macro Script needed
hi all , I have a column AI in which dates are given in (MM/DD/YYYY) I am looking for a macro which selects all the dates in Column AI apart from today's date . If anyone can help !!!- kshitij_dch
- Thread
- column dates macro selects todays
- Replies: 7
- Forum: Excel Questions
-
K
VBA - Select multiple ranges using ActiveCell.Row
I'm trying to select cells B*:D* and H*:APP*. where *= active.cell.row. I do not want to select E*:G*. Can't seem to get this to work & would appreciate a little help please. When I try this code it selects everything including E*:G* Sub Macro1() Dim Ro As Integer Ro = ActiveCell.Row...- Kenn
- Thread
- activecell.row code inclucing select selects
- Replies: 3
- Forum: Excel Questions
