Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by tripg
-
Using Command Button to Offset Excel Selection
Skip, On a side note, while the button is directly on the sheet and not on a form, there is no delay at all. It can handle the speed. So where is the code slowing down once a form is introduced?- tripg
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using Command Button to Offset Excel Selection
Skip, If I click within 1.5 seconds it will not offset. Is there a way to lock the command button then while the code is running?- tripg
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using Command Button to Offset Excel Selection
The cursor is active on an active excel sheet. A form is open. On Clicking a command button on the form, I want the cursor to offset one row. I am using the following: Private Sub btnLOCback_Click() Selection.Offset(-1, 0).Select End Sub When I click the command button the first time, it...- tripg
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
add "spin button" on access form
To display an arrow on a command button I change the text style to "wingdings 3" and use the letters 't' and 'u'.- tripg
- Post #14
- Forum: VBA Visual Basic for Applications (Microsoft)
