Hi all,
when i choose material from my combobox Options (cboTM), i wanted, only the textboxes regarding to the sheet material unlocked, and the others locked with the color of the form, and the same for the other options like worklabor and equipments. i could blocked for material with this code :
the prob is , worklabor and equipments will be blocked too, and i dont know how to put the correct info on the textboxes
Please Login or Register to view this content.
Last edited by Nuno Neves; 03-29-2014 at 07:18 AM.
Try something like this. I don't know what textboxes you want enabled for worklabor and equipments.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
For materials all worked well
for Worklabor and equipments,(after i changed the required texboxes to false) only the opaque didnt worked
the other thing was, how i put the correct info on the texboxes :
if i choose "materials" from cboTM, and option 1 ("B7") from cboDM, textemp and textHours will become blocked :
(sheet Material)
textmeasure ="C7"
textQuant="D7"
textprice="E7"
texttprice="F7"
same to Worklabor :
if i choose "worklabor" from cboTM, and option 1 ("B7") from cboDM, textQuant will become blocked :
(sheet Worklabor)
textmeasure ="C7"
textemp="D7"
textHours="E7"
textprice="F7"
texttprice="G7"
and the same for Equipents....etc..
i attached my file with the alterations
Last edited by Nuno Neves; 03-24-2014 at 02:26 PM.
i could solve almost my main issue. however i found 2 problems.
1) the data that is displayed on the textboxes named "textprice" and "texttprice" are formated as currency, but in both textboxes and cells they are formated as currency.
2) for one sheet i could get the info onall textboxes. But for the other sheet, i am getting error, i believe is because exist a conflict with the textboxes that are the same for the 3 sheets i am using. dont know how to solve this.
my code :
Please Login or Register to view this content.
i attached my file too, to help better understanding.
Thks in advance.
You're welcome.
Moved the cboTM_Exit code to the cboTM_Click procedure. Delete cboTM_Exit.
Please Login or Register to view this content.Please Login or Register to view this content.
Perfect
Now i see the noobish i was doing, using the match funcion instead the offset. At the time i didnt understood the offset. But now i can see how simple is.
so simple and fluid the code become
Its by valuabe contributors like you,that noobs like me evolve learning with the bests.
Thks you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks