vba:: Create a toggle button with code 누를때마다 글자변경

버튼을 누를 때 마다 표시되는 문구가 달라지는 매크로 버튼 하나로 단계적 절차를 표현할 때 활용가능 Sub Calculate() Application.ScreenUpdating = False With ActiveSheet.Buttons(Application.Caller) If .Caption = "Sum" Then Cells(12, 1).Value = "=R[-2]C+R[-1]C" Cells(12, 2).Value = "=R[-2]C+R[-1]C" Cells(12, 3).Value = "=R[-2]C+R[-1]C" Cells(9, 1).Value = .Caption .Caption = "subtract" ElseIf .Caption = "subtract" Then Cells(12, 1).Value = "..

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 2. 13.
  • textsms

VBA:: Searching with System.Collections.ArrayList

* 링크 못 찾음 Thus, I was thinking that there should be a fast way to calculate the first few numbers with System.Collections.ArrayList as far as I have written about a helper to sort arrays and range sorter. So, as far as it can be obviously solved with a N^2 complexity algorithm it is quite easy to be done: Public Sub TaxiCabNumber() Dim a As Long Dim b As Long Dim lastNumber As Long Dim cnt As Lo..

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 2. 13.
  • textsms
VBA:: Hide the Named Ranges in Excel

VBA:: Hide the Named Ranges in Excel

*스크랩 링크 못 찾음.. Yup! The named ranges are visible. You “SpecialPassword” can be seen by anyone. What should you do? Option 1 – use a database and proper hashing for storing of sensitive information. Option 2 – hide the names, from the Name-Manager, thus the worksheet would still refer them, but they will be not visible: This is the way to achieve it with VBA: Sub UnhideAllNames() Dim tempName As ..

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 2. 13.
  • textsms
vba:: 스크랩 useless Select, Activate, ActiveCell, Set Range

vba:: 스크랩 useless Select, Activate, ActiveCell, Set Range

여기저기 관련글 스크랩  Using useless Select, Activate, ActiveCellUsing Select, Activate and ActiveCell in VBA can bring problems. And shows problems. In general, if you use the macro-recorder and record a macro, then you would see lots of Select, Activate, ActiveCell and etc. And it would work. Then why is it a problem?It is slow. All these .Activate and .Select actions take time.It is not necessa..

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 2. 13.
  • textsms

VBA:: Copying Excel worksheet to a new workbook without leaving the old Excel reference (보호)

보호되어 있는 글입니다.

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 2. 13.

excel:: Index(Match) based on multiple columns (보호)

보호되어 있는 글입니다.

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 2. 13.