Hi ExcelFox
Thanks
I am slowly learning VBA ( alot from this site)
I did try by adding the following code which i changed from bakerman original code(very helpful)...bakerman then came back and...
Type: Posts; User: paul_pearson
Hi ExcelFox
Thanks
I am slowly learning VBA ( alot from this site)
I did try by adding the following code which i changed from bakerman original code(very helpful)...bakerman then came back and...
Hi
Nothing wrong with being insistent
This has nothing to do with C.F
Thanks
Hi
On the data sheet XFLOW A for 13/9/2013 & 14/9/2013 for Total the rows are blue....can all rows with either Total or Grand Total have no color...no color in cells/rows which have the word Total...
Thanks bakerman
Can this one be fixed...if so this is finished
On the data sheet XFLOW A for 13/9/2013 & 14/9/2013 for Total the rows are blue....can all rows with either Total or Grand Total...
Another
On the data sheet XFLOW A for 13/9/2013 & 14/9/2013 for Total the rows are blue....can all rows with either Total or Grand Total have no color
Thanks again
Thanks Bakerman
I am confident this is the last part and the workbook is completed
If i run this code below with no entries in the data sheet it brings up an error...can something be added in...
Bump
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgykemWTw-fGoPwu8E14AaABAg.9iECYNx-n4U9iK75iCEaGN
...
Hi
I have the cells fill in with color for Production,Planned Stop and Internal for Machine Stoppage......
1. How can the code be changed so that when Machine Stoppage is used it fills in the...
Thanks bakerman for all your help....appreciated
Thanks again bakerman
All works well and i guess you are most likely getting tired of this thread but 1 last go
If i enter a date and machine i can send data without it having all the fields...
Thanks bakerman
That solved.....no error but if i select External and it combobox`s ,fill in a comment and then Transfer Data a messagebox asks for me to select a Part which is disabled in the...
Thanks bakerman
Added the code (possibly in the wrong place) and set the Enabled-property of the CB's and both TB's to False
If i select date and machine and press Transfer Button it messagebox...
Thanks for all your help bakerman...the code above worked
I did find 2 errors...i used the Tag property in the userform for the Combobox`s and Textbox`s and they work...i used the Tag Property for...
Thanks bakerman
Works....if i select Internal or External can the Time textbox`s also be disabled (entry deleted) on the 1 not selected.
If changing from say Internal to External it removes the...
Thanks
I did have a version where I placed all in the 1 frame...I am stilling working on it but it does work on some features.The issues I am having is if I select Internal and its selections from...
Thanks Bakerman
I added a couple of text box`s to the userform and changed in the code...the data transfers to the correct cells...your code change for the Optionbutton works well but my only...
If Internal optionbutton selected then External optionbutton and its comboboxs not available and if External optionbutton selected then Internal optionbutton and its comboboxs are not available...
thank you
password = abc
The info is now available in the userform...when I select Internal I need the External Option unavailable and visa versa....for this to work would I need both the...
I though whatsheet is if you were asking me what sheets...another point learnt
I am not sure with the Private Sub category_select()....i did change the comboboxs around but they are not visible in...
Thank you bakerman
I made a few changes which at least allowed me to open the userform.The date now appears in Combobox1...i deleted some code from the Post#1 sheet...I am still not there with the...
Hi
The code worked fine while using Combobox`s but I prefer to use Optionbuttons in a few changes.I searched but have not worked out how to change the code from combobox to optionbutton
1....
Very nice bakerman...it worked on the Userform which was attached in Post#1
I have changed the Combobox2 on the 3 userforms which selects which machine and replaced with optionbuttons...also...
Hi
I have userform "Production" transferring data to the correct cell range....need help getting the code to transfer "Planned Stop" and Machine Stoppage
All dates for Userforms called...
Thank you Excel Fox
Hi
With the userform in the "Category" Combobox if "Internal" is selected then the "External" Combobox entries are not visible/cannot be selected...if Category "External" selected then "Internal"...