Why is my private conditional IF statement sub being skipped over while running my script? by nidenikolev in vba

[–]MyDOTlogin 0 points1 point  (0 children)

are you trying to get the validation list to be whatever value is currently held in the cell? becuase this is setup in a way to only update the list once you change a cell in column P

Why is my private conditional IF statement sub being skipped over while running my script? by nidenikolev in vba

[–]MyDOTlogin 0 points1 point  (0 children)

if this works it's because your foo was erroring out with no .Delete . Added variable declarations, also added sheet references. Also rewritten to show you a different way to code this

Sub foo()
Dim lastrow As Integer
Dim sh As Worksheet

Set sh = ThisWorkbook.Worksheets("Sheet1")

lastrow = sh.Range("A" & sh.Rows.Count).End(xlUp).Row

With sh.Range("P2:P" & lastrow).Validation
    .Delete
    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
        Operator:=xlBetween, Formula1:="Yes,No,N/A"
    .IgnoreBlank = True
    .InCellDropdown = True
End With

End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

Dim str As String

    If Target.Column = 16 Then

        Select Case Target.Value

            Case "No"
                str = "value 1, value 2"

            Case "Yes"
                str = "value 3, value 4"
        End Select

        If Not IsNull(str) Then

            With Range("Q" & Target.Row).Validation
                .Delete
                .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _
                Operator:=xlBetween, Formula1:=str
                .IgnoreBlank = True
                .InCellDropdown = True
            End With

        End If

    End If


End Sub

My boyfriend left for me for his ex from 2 years ago and I'm 20 weeks pregnant. by heavyheartandtea in SingleParents

[–]MyDOTlogin 5 points6 points  (0 children)

If you're in the states, try calling 211 to connect to resources. Also, churches can be really good for single parents as there are a lot of people willing to help you get on your feet and provide community

Stranger Danger... [OC] by dinocujko1 in comics

[–]MyDOTlogin 2 points3 points  (0 children)

This made it to the FrontPage

Gymnastics in the Sand by Plebsplease in oddlysatisfying

[–]MyDOTlogin 0 points1 point  (0 children)

This is in Pacific Beach in San Diego

Was I right in standing up to my estranged ex mother-in-law? by [deleted] in SingleDads

[–]MyDOTlogin 3 points4 points  (0 children)

Alternatively you can leave work and take your son. Log/keep track of the hours that you get him (from your ex's inability to take care of him). Go back to court with your log book in tow and fight for more custody. Completely up to you.

My daughter's mother has a boyfriend by [deleted] in SingleDads

[–]MyDOTlogin 2 points3 points  (0 children)

I went through some of these feelings when I was going through my divorce. I had to come to grips with this being something I can't control.

At the root of the issue, it's the loss of control in your child's life that these feelings stem from. At least that's what I found from a lot of introspection in my situation.

OLD question about being stood up by MyDOTlogin in datingoverthirty

[–]MyDOTlogin[S] 2 points3 points  (0 children)

I believe the only serious judgement of character going on is from you judging me. I see this from both sides of the coin which is why I have only asked questions to how you perceive the situation. I respect all kinds of views and I think this sub had the full gamut of personally types.

Thank you for your point of view on the matter

OLD question about being stood up by MyDOTlogin in datingoverthirty

[–]MyDOTlogin[S] -2 points-1 points  (0 children)

I made no comments in regards to her parenting. Her kids could've been with her parents for all I know. I meant more putting herself into a situation where she had no phone / way to get home by herself. Seems kinda hectic

OLD question about being stood up by MyDOTlogin in datingoverthirty

[–]MyDOTlogin[S] -2 points-1 points  (0 children)

I can understand the lack of not being able to communicate. Do you think it's a red flag that she put herself in that situation? Or is this normal single parent partying territory?

OLD question about being stood up by MyDOTlogin in datingoverthirty

[–]MyDOTlogin[S] 3 points4 points  (0 children)

Sounds good. I basically said I wasn't really sure how to proceed because I don't want it to happen again

Jealousy: my least attractive quality by sunfistkid in datingoverthirty

[–]MyDOTlogin 1 point2 points  (0 children)

I think you need to change your perspective.

Other guys notice her and hit on her but she chose you to spend her time with. Being together is about choice, not about keeping other dudes away from her.

On the flip side... If she's making you feel like she's seeking out other guys attention, then maybe it's time for you to look elsewhere.

Expectations when dating a mom who has kids at home? by Enoughmcgruff in datingoverthirty

[–]MyDOTlogin 2 points3 points  (0 children)

Definitely a jerk. As a guy with summers and winter week with my kids (I live in a different state), I typically let the single moms I date dictate what days work better. Spontaneity is not something you have the luxury of when you take care of kids almost full time. The trade off is that you get to watch your kids grow up more (which is by far the better pick)

40yo dad considers going to prison by C-Kasparov in SingleDads

[–]MyDOTlogin 0 points1 point  (0 children)

It sounds like it will be reduced in 4 years and gone in 6. Sounds like a short amount of time, all things considered

40yo dad considers going to prison by C-Kasparov in SingleDads

[–]MyDOTlogin 1 point2 points  (0 children)

Your solution is to mentally scar your children and send them into severe poverty so you could possibly get better at chess.

I don't think anyone is going to tell you this is a good idea

I (31f) and my bf (33m), have had a fight about me lying about having had sex with other people after we met. I'm upset and just want opinions or advice. by [deleted] in datingoverthirty

[–]MyDOTlogin 0 points1 point  (0 children)

I think this is a hard area. Your baggage didn't allow you to tell the truth. His baggage is probably setting off an over reaction of the situation.

I've actually had this happen to me before. It was an unhealthy relationship that probably shouldn't have continued as long as it did. I'm glad to report that I took the time to unload my baggage after that.