Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
With Application.FileDialog(msoFileDialogSaveAs)
' .InitialFileName = "c:\users\x\documents\"
.FilterIndex = 1
.InitialFileName = FILENAME1
.Title = "Opslaan als"
.Show
.Execute
End With
c00 = Join(Array([P8], [Q8], [I9], [I13], [I29], [I30]), "-")
wat houdt die trim functie eigenlijk in? neemt die bijv. de spatie's in?
Sub Keuzerondjes_Klikken()
Dim Kleur As Long
Select Case Application.Caller
Case "Jongen": Kleur = 14853632
Case "Onbekend": Kleur = 9158777
Case "Meisje": Kleur = 12495092
End Select
ActiveSheet.Shapes("MultiFrame 1").Fill.ForeColor.RGB = Kleur
End Sub
Sub SAVE_AS()
Dim trim
Dim FILENAME1 As String
Dim sh As Worksheet
FILENAME1 = Join(Array(Range("P8"), Range("Q8"), Range("I9"), Range("I13"), Range("I29"), Range("I30")), "-")
Sheets(Array("DECLARATION", "CHART STICKER")).Copy
ActiveWindow.Activate
With Application.FileDialog(msoFileDialogSaveAs)
.InitialFileName = "c:\users\x\documents\"
.FilterIndex = 1
.InitialFileName = FILENAME1
.Title = "Opslaan als"
.Show
.Execute
End With
With ActiveWorkbook
For Each sh In .Sheets
If LCase(sh.Name) = "declaration" Then
sh.Shapes.Range(Array("Button 1", "Button 2", "Button 3", "Button 4", "Button 5")).Delete
End If
For Each next sh
If LCase(sh.Name) = "chart sticker" Then
sh.Shapes.Range(Array("Button 1", "Button 3")).Delete
End If
End With
End Sub
With ActiveWorkbook
For Each sh In .Sheets
If LCase(sh.Name) = "declaration" Then
sh.Shapes.Range(Array("Button 1", "Button 2", "Button 3", "Button 4", "Button 5")).Delete
End If
Next sh
If LCase(sh.Name) = "chart sticker" Then
sh.Shapes.Range(Array("Button 1", "Button 3")).Delete
End If
End With
With ActiveWorkbook
For Each sh In .Sheets
Select Case LCase(sh.Name)
Case "declaration"
sh.Shapes.Range(Array("Button 1", "Button 2", "Button 3", "Button 4", "Button 5")).Delete
Case "chart sticker"
sh.Shapes.Range(Array("Button 1", "Button 3")).Delete
End Select
Next sh
End With
nu heb ik de fout 1004 opgelost omdat de button 1 moest button 2 zijn. dus dat is opgelost maar nu komt er een andere naar voren.
fout -2147024809 (80070057) tijdens uitvoering:
de opgegeven waarde valt buiten het bereik.
Select Case Application.Caller
Case "Jongen"
Kleur = 14853632
Case "Onbekend"
Kleur = 9158777
Case "Meisje"
Kleur = 12495092
End Select
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.