DB73
Board Regular
- Joined
- Jun 7, 2022
- Messages
- 102
- Office Version
- 365
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
- Mobile
- Web
hi guys,
i've got al little (big) problem
got 2 commandbuttons (cmdb1, cmdb2)
cmdb1 is working and opens my userform
cmdb2 (factuur) is on the same sheet but doesnt seem to work ??
i use these 2 codes to call my userforms;
tried to remove the buttons and make new
checked 100 times if the name was correct.
i use office365
fault code is "Subscript Out of Range Runtime Error (Error 9)"
also noticed that as i open the userform the window is just out of my screen, i make it fit everytime but after openening the spreatsheet again, its too wide again
what could it be ?
thanks in advance
i've got al little (big) problem
got 2 commandbuttons (cmdb1, cmdb2)
cmdb1 is working and opens my userform
cmdb2 (factuur) is on the same sheet but doesnt seem to work ??
i use these 2 codes to call my userforms;
VBA Code:
Private Sub CommandButton1_Click()
MyForm.Show
End Sub
Private Sub commandbutton2_Click()
Factuur.Show
End Sub
checked 100 times if the name was correct.
i use office365
fault code is "Subscript Out of Range Runtime Error (Error 9)"
also noticed that as i open the userform the window is just out of my screen, i make it fit everytime but after openening the spreatsheet again, its too wide again
what could it be ?
thanks in advance