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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
excel cell input validation
Hi All, I' trying to set a cell so the user can only input a 11 digit number that can start with a zero and contain no spaces. this is what I have thank for any assistance this is set via the data validation =AND(ISNUMBER(a1),LEN(a1)=11)- DJ2018
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
excel aba variable range help
Hi Guys, I need to remove blanks from a variable range e4:g - variable ive managed to replace the blanks but only on a fixed range. here is what I have. Private Sub cmdClean_Click() Const sBad As String = "`!@#$;^()_-=+{}&[]\|;:'"",.<>/?" Dim cell As Range Dim s...- DJ2018
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
excel vba search btn
Hi guys im trying to create a searchable user form but have come unstuck. When I enter the search details in txtAmount - my search box; hit the find btn, I get a runtime error 9 Subscript out of range. This is my code any help would be cool. Private Sub cmdFind_Click() Dim totRows As Long, i...- DJ2018
- Thread
- Replies: 13
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel set print area onclick
Hi guys I returning to this after 15 yrs out and my memory is poor. So any help would be fantastic. I have a button to select a range and print. Private Sub cmdbtnPrint_Click() ActiveSheet.Select Range("A3:F21").Select ActiveSheet.PageSetup.PrintArea = "A3:F21"...- DJ2018
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
