Log In
Register
Home
Active Member
May 20, 2023
Offline
Could someone please tell me why im getting a vba error in this excel database when adding data please
im just learning excel Thanks
Trusted Members
October 18, 2018
Offline
Attached file is unreadable. Please try again.
Active Member
May 20, 2023
Offline
Try this one
Active Member
May 20, 2023
Offline
here it is as a zip
Trusted Members
October 18, 2018
Offline
unable to assist. File is locked as read only and cannot change on my side. Macro will not run as it is blocked by security on your end. Sorry. Good Luck.
Trusted Members
Moderators
November 1, 2018
Offline
How big is your monitor? Your userform is over 6k pixels wide, which makes it extremely hard to use!
Active Member
May 20, 2023
Offline
@Velouria Ok i have to add code to stop it from resizing don't know why it dose it sometime? i been going into vba and resize it back to original size.
Trusted Members
October 17, 2018
Offline
The userform is not resizing the userform settings are set to this size.
It's very bad coding and the error, well that's another issue.
O yes, and which version of Excel are you using?
Trusted Members
Moderators
November 1, 2018
Offline
It sounds (and looks) to me as though there may be some corruption in your workbook. I'd suggest rebuilding it.
The following users say thank you to Velouria for this useful post:
Alan SidmanTrusted Members
October 17, 2018
Offline
When you look at the form size it's set to huge width and height.
Question of redesigning the userform and if needed use the zoom function.
Nothing to do with corrupted workbook for as far as I can see.
The OP has not informed us of the Office version he's using
Trusted Members
Moderators
November 1, 2018
Offline
Look at the controls on the form - do any of them look right to you? They all look distorted and they appear much bigger than their properties suggest they should be. For example, cmbShop is a combobox that is 150 pixels wide but it barely fits on my 1920x1080 monitor!
Trusted Members
October 17, 2018
Offline
I honestly don't knwo what you have done but the size of the values in the Userform is out of bounds.
Furthermore the code is, if I may say so, very unprofesiionally built without any real 'intelligence built into it.
I made some adjustments to the form so that it's readable and visible like it should, but the code behind the buttons , well ...
Hope you can work witth this version and I suggest you lookup some code snippets and ideas on-line to make it user friendly.
Sorry for the 'bites' but as a VBA coder it hurts to see code like this
1 Guest(s)
