Posts by Trish123

  • Trying to hide rows based on a drop down yes no

    Re: Trying to hide rows based on a drop down yes no


    This works a treat Grimes0332,


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$E$22" Then
    Rows("25:28").Hidden = UCase(Target.Value) <> "YES"
    End If

    If Target.Address = "$E$23" Then
    Rows("31:33").Hidden = UCase(Target.Value) <> "NO"
    End If

    If Target.Address = "$D$49" Then
    Rows("50:52").Hidden = UCase(Target.Value) <> "YES"
    End If

    End Sub



    Just one last question is it possible to have the cell saying please select" YES/NO" or just YES/NO in the cell keeping the cells hidden until the YES/NO is selected.

  • Trying to hide rows based on a drop down yes no

    Re: Trying to hide rows based on a drop down yes no


    Hi Grimes0332,


    That works a treat, this is a very dumbo question to be asking but i am becoming a bit brave, firstly i also want Rows 25:28 and 31:33 to be also automatically hidden on entry to the form and i have 2 other cells with a drop down YES/NO (cell E22 and E23)
    So when Cell E22 = YES to show cells 25:28
    and when Cell E23 = NO to show cells 31:33.


    How would i put this into the code that you have given.

  • Trying to hide rows based on a drop down yes no

    Re: Trying to hide rows based on a drop down yes no


    The following is the code that i have figured out will work, but how would i modify this that the information is hidden until the YES is entered;
    any ideas


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$B$1" Then
    Application.EnableEvents = False
    If UCase(Target.Value) = "NO" Then
    Rows("3:5").Hidden = True
    Else
    Rows("3:5").Hidden = False
    End If

    Application.EnableEvents = True
    End If
    End Sub

  • Link to upload a document

    Re: Link to upload a document


    Grimes0332
    apologies i know i am trying to explain as best i can, when i am inserting this code how do i reflect this on the cell , am i to put in a button for the to press, and then put this code onto the button. and when the pdf, word or picture document is uploaded how is it shown so that when it comes back to be that i can just click on it to open it on my side.

  • Link to upload a document

    Re: Link to upload a document


    Hi Grimes 0332,


    Thank you so very much for that, but with regards to the map, this may be a picture but is also could come in a pdf. version or maybe even pasted onto a word document.
    granted I have not sent on the form but all i have is the question asking to upload map if available and to enter contact details etc, i am just trying to make it as user friendly as i possibly can.

  • Link to upload a document

    Re: Link to upload a document


    [TABLE="width: 1155"]

    [tr]


    [td]

    4.

    [/td]


    [td]

    Please attach a Map if available when returning this document.

    [/td]


    [TD="colspan: 3"] [/TD]

    [/tr]


    [/TABLE]
    I dont have anything else really just above really, but yes i would like then to be able to select a file and upload it sot that it will then be available to me when sent back

  • Link to upload a document

    Re: Link to upload a document


    Hi Grimes 0332,
    I will be sending a basic information form to persons, but i am looking for a way for them to attach a document to the form i know i will be able to get them to forward the attachment along with the form anyway but if it is possible for me to even have a button or an option for them up upload file. so when it is sent back to me all i would have to click on is place on the form. again i dont know if this is even possible, as i am just an intermediate user of excel and only very basic programming skills.

  • Link to upload a document

    Hi,


    I have a form created but i would like a way to allow user to attach a document, they will be on a different network so it will not be froma shared drive, if this is at all feasible.


    Trish123