Advertisement
ALEXANDAR_GEORGIEV

Untitled

Nov 29th, 2024
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 'Трябва да ги сложи в ComboBox3 taka:
  2. ComboBox3.addItem "sk_materials"
  3. ComboBox3.addItem "sk_stocks"
  4. ......
  5. .....
  6.  
  7.  
  8. Private Function CheckIfSheetExist(SheetName As String)
  9.     Dim ws As Worksheet ', sheetName As String
  10.    For Each ws In ThisWorkbook.Worksheets
  11.         If ws.Name = SheetName Then
  12.             CheckIfSheetExist = True
  13.             Exit For
  14.         Else
  15.             CheckIfSheetExist = False
  16.         End If
  17.     Next ws
  18. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement