VBA Tips & Trick: Cara Menampilkan Grafik/Chart kedalam UserForm dengan VBA

  Рет қаралды 9,853

Andi Setiadi

Andi Setiadi

Күн бұрын

Pada Video Tips and Trick #VBA kali ini adalah begaimana cara menampilkan Grafik atau Chart kedalam sebuah Userform
Script dibuat secara sederhana dan dijelaskan ditiap barisnya. Agar teman-teman mudah memahaminya.
Jika ada pertanyaan atau Saran masukan silahkan tuliskan dikomentar ya
Script:
Sub LoadGrapik(SChart As String, ImgCtrl As Control)
Dim NmChart As Chart
Dim NmFile As String
NmFile = ThisWorkbook.Path & "\tmp1.Gif"
Set NmChart = Sheet1.ChartObjects(SChart).Chart
NmChart.Export NmFile, "GIF"
ImgCtrl.Picture = LoadPicture(NmFile)
End Sub
#graph

Пікірлер: 33
5 TRIK RAHASIA di Excel Buat Kerjaan Selesai Lebih Cepet!
16:36
Ignasius Ryan
Рет қаралды 515 М.
Wednesday VS Enid: Who is The Best Mommy? #shorts
0:14
Troom Oki Toki
Рет қаралды 50 МЛН
«Жат бауыр» телехикаясы І 30 - бөлім | Соңғы бөлім
52:59
Qazaqstan TV / Қазақстан Ұлттық Арнасы
Рет қаралды 340 М.
UI DASHBOARD USERFORM EXCEL PART 1 | EXCEL & VBA TUTORIAL
42:15
EXCEL & VBA TUTORIAL
Рет қаралды 11 М.
Excel VBA UserForm How to Display a Chart in a UserForm
7:33
InAnOffice
Рет қаралды 18 М.
Displaying a Chart in a UserForm dynamically
17:27
TheDataLabs
Рет қаралды 45 М.
VBA: Dynamic Charts in User Form
12:32
PK: An Excel Expert
Рет қаралды 38 М.
Cara Membuat DatePicker di VBA Excel
9:58
Bukit Tutorial
Рет қаралды 1,2 М.
TRIK MENGAKTIFKAN LEBIH DARI SATU USERFORM DAN SHEET |  EXCEL & VBA TUTORIAL
13:32
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 1,1 МЛН
PIVOT CHART: KEREN! Visualisasi Dashboard Menggunakan Excel
16:18
Yuliana Epianingsih
Рет қаралды 270 М.
VBA Tips & Trick: Cara Menambah Icon Ke Userform VBA
14:30
Andi Setiadi
Рет қаралды 5 М.
Wednesday VS Enid: Who is The Best Mommy? #shorts
0:14
Troom Oki Toki
Рет қаралды 50 МЛН