KO
English
Deutsch
Español
Français
Italiano
Português
Nederlands
Polski
Bahasa Indonesia
Русский
Українська
العربية
עברית
日本語Visual Basic for Applications (VBA)
Product
Microsoft event-driven programming language built into most desktop Microsoft Office applications, used for example to automate tasks in Excel.
| Type | Product |
|---|---|
| Wikipedia | en.wikipedia.org/wiki/Visual_Basic_for_Applications |
Articles about Visual Basic for Applications (VBA) (5)
- Excel에서 셀을 잠그는 방법: 수식 보호하고 입력은 허용하기
· Mirko Peters
Excel에서 셀을 잠그는 방법입니다. 입력 셀의 잠금을 먼저 해제한 다음 검토, 시트 보호를 선택하세요. 수식을 숨기고, 사용자가 지정된 범위를 편집하도록 허용하고, 흔히 발생하는 문제를 해결하는 방법도 함께 설명합니다. - Excel에서 중복 항목을 제거하는 방법: 명령, 수식, Power Query
· Mirko Peters
Excel에서 중복 항목을 제거하는 방법을 정리했습니다. 데이터 탭의 중복 항목 제거 명령을 쓰거나, UNIQUE 함수, 수식, Power Query로 원본 데이터를 그대로 둔 채 결과를 만드는 방법까지 단계, 제한 사항, 흔한 실수를 함께 다룹니다. - How to Unhide All Rows in Excel (Including Row 1)
· Mirko Peters
How to unhide all rows in Excel: select the whole sheet, then Home, Format, Hide & Unhide, Unhide Rows. Also row 1, filtered rows, a macro and stubborn cases. - How to Remove Duplicates in Excel: Command, Formulas, Power Query
· Mirko Peters
How to remove duplicates in Excel: use Data, Remove Duplicates, or keep the original data with UNIQUE, formulas and Power Query. Steps, limits and mistakes. - How to Lock Cells in Excel: Protect Formulas, Allow Input
· Mirko Peters
How to lock cells in Excel: unlock the input cells, then use Review, Protect Sheet. Also hide formulas, let people edit set ranges, and fix common problems.
Community wiki
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.
Sources
- Wikipedia: en.wikipedia.org/wiki/Visual_Basic_for_Applications
- Feed for this topic (RSS): entity/vba/feed.xml
- Articles on this topic: 5
Maintained by Mirko Peters (Microsoft MVP) · Last updated: