Search:

Type: Posts; User: paul_pearson

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Hi ExcelFox Thanks I am slowly learning VBA (...

    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...
  2. Hi Nothing wrong with being insistent This...

    Hi

    Nothing wrong with being insistent

    This has nothing to do with C.F

    Thanks
  3. no color in rows which have the Total or Grand Total

    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...
  4. Thanks bakerman Can this one be fixed...if so...

    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...
  5. Another On the data sheet XFLOW A for...

    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
  6. Thanks Bakerman I am confident this is the...

    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...
  7. Bump ...

    Bump

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgykemWTw-fGoPwu8E14AaABAg.9iECYNx-n4U9iK75iCEaGN
    ...
  8. fill in cells according to selected optionbutton

    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...
  9. Thanks bakerman for all your help....appreciated

    Thanks bakerman for all your help....appreciated
  10. Thanks again bakerman All works well and i...

    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...
  11. Thanks bakerman That solved.....no error but...

    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...
  12. Thanks bakerman Added the code (possibly 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...
  13. Thanks for all your help bakerman...the code...

    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...
  14. Thanks bakerman Works....if i select Internal or...

    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...
  15. Thanks I did have a version where I placed all...

    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...
  16. Thanks Bakerman I added a couple of text box`s...

    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...
  17. If Internal optionbutton selected then External...

    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...
  18. thank you password = abc The info is now...

    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...
  19. I though whatsheet is if you were asking me what...

    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...
  20. Thank you bakerman I made a few changes which at...

    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...
  21. changing code from using Combobox to optionbuttons

    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....
  22. Very nice bakerman...it worked on the Userform...

    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...
  23. data entry to correct cell range...code needs help

    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...
  24. Thank you Excel Fox

    Thank you Excel Fox
  25. Enable And Disable Controls Based On Selection In Previous Combo Box

    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"...
Results 1 to 25 of 107
Page 1 of 5 1 2 3 4