when i open this userform the option buttons default to "no"....when i click the ADD PROJECT button my the code does not recognize that the option buttons are selected on "no"...unless i toggle them prior to pushing ADD PROJECT.
here is the add project code: (sample form attached)
Please Login or Register to view this content.
Hi adam,
Look at the Properties of those options buttons and change the default VALUE = True instead of false.
You need to show the properties window and click on the option button you want to change. Then look down the list of properties to Value and change that False to a True.
I hope that is what you need. If not then keep asking.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi MarvinP, i do have those option button values set to True. When the userform opens the option buttons are set to No like i need...but when i click the add button it should return the result of "0" into a specific cell....if i dont click on any of the option buttons and i click the add button it returns no value even those the option button is on.
Hi adam,
I guess I don't understand the problem. You can set properties using VBA and you can query them using VBA. Is it your code that isn't working or the default settings that are changing?
Yes the code seems to be the problem. The option buttons should return a value of 1 or 0 along with all the other date entered. but they only work when i use the update button...not the add button.
so if you go into the sample...enter a job number and then click add...it should populate all the option buttons as "0" for that row.
I thought it might be becuase i have this part:
Please Login or Register to view this content.
in front of this part:
but when i switch them, it's not clearing...and it still doesn't return any value.Please Login or Register to view this content.
Please Login or Register to view this content.
so a solution i think is to change this:
to just:Please Login or Register to view this content.
that way a "0" just gets entered into the cell. so i made that change and now i'm getting a syntax error. with the End with ??Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by adamheon; 07-16-2016 at 02:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks