CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online log in · register
Home › Gerald Smith89 › Posts

Posts by Gerald Smith89

2 posts shown.

I was watching some highlights late last night, and it got me thinking about how much the entire culture of being a fan has shifted in the last decade. It feels like we can’t even enjoy a single game anymore without the constant, looming shadow of "the next superstar" hanging over every single play.

I remember being a kid watching games back in the day. You’d see a player put up a massive season, maybe win a few awards, and you’d just enjoy the ride. There was a certain level of patience involved. You watched a guy develop, you saw him struggle, you saw him peak, and you appreciated the journey. It was about the player in the jersey right in front of you. But now? It feels like the moment a kid even touches a professional field or steps onto a pitch, the hype machine starts grinding immediately.

It’s like we’ve become obsessed with the *potential* of a person rather than their actual current reality. We spend more time scrolling through advanced metrics, scouting reports, and "can't-miss" projections than we do actually watching the games themselves. I catch myself doing it too, which is the frustrating part. I’ll be sitting there, and instead of watching the tactical battle unfolding on the field, I’m thinking, "Man, if this kid lives up to the Twitter rumors, he’s going to be a legend by 24." We are constantly living in a future that hasn't happened yet, which robs us of the present moment.

There’s a psychological component to this that I think we don't talk about enough. The "Next Big Thing" narrative creates this intense, almost toxic level of expectation. When a highly-touted prospect finally gets their shot, they aren't just playing against the opposing team; they are playing against the impossible standard that the internet and the media have built around them. If they don't hit a home run or make a game-winning play in their debut, the "bust" labels start flying before they've even had a chance to grab a cup of coffee in the locker room. It seems incredibly unfair to these young athletes. They are essentially being asked to carry the weight of an entire franchise's hope before they've even mastered the fundamentals of the professional level.

And then there’s the impact on the actual fans. I feel like the "die-hard" experience has become fragmented. You have the traditionalists who just want to see a good game, and then you have the "stat-heads" and the hype-chasers who are basically playing a real-life version of a fantasy sports simulator. The tension between those two groups is palpable. You see it in the comment sections and on social media every single day. One side is screaming about "tanking for draft picks" or "waiting for the phenom," while the other side is just trying to talk about how the bullpen looked shaky in the 7th inning.

I wonder if this hyper-focus on youth and "ceiling" is actually hurting the longevity of players' careers. We celebrate the meteoric rise, but we have zero patience for the slow burn. We’ve become a "disposable" culture, even in sports. If you aren't the shiny new toy, you're suddenly yesterday's news. It makes me wonder if we're losing the ability to appreciate the veteran players—the guys who might not have the "superstar ceiling" but provide the grit, the leadership, and the consistency that actually wins championships.

I want to start enjoying the game again without feeling like I'm constantly checking a countdown clock to see when the next generational talent is going to debut. I want to appreciate the grind. I want to appreciate a guy who has played ten seasons and knows exactly how to handle a high-pressure situation, rather than just being enamored by a teenager with a high exit velocity.

Does anyone else feel like the constant hype cycle is making it harder to actually enjoy being a fan? Or am I just being a cynical old man who misses the days when we didn't know every player's projected WAR before they even stepped on the field?
Greetings everyone. I am new here and just registered today. I have spent quite a bit of time searching through Google and visiting local libraries, but overall, I haven't found much regarding VBA programming, especially in the English language.

That said, there are some interesting tutorials on YouTube, which have helped me pick up a few things.

However, I have stumbled upon a specific problem that I cannot seem to resolve.

I have created a user form (UserForm1) where I input certain values. These values are then recorded onto an Excel sheet, where Excel performs the necessary calculations and displays the results in a second textbox on the form. Everything functions perfectly until I hit this particular snag.

So, my question is this:

Is it possible to have a single textbox display a value based on a specific cell range?

To put it simply, the logic would be roughly this:

If a specific cell's value falls within a certain range (for example, M8:M15), display that value in TextBox17.

In my current setup, the form contains one command button and one textbox.

If anyone knows how the code should be structured, I would be very grateful if you could provide an example.
I managed to draft something myself, but I can only get the value to show up in seven different textboxes rather than just one.

The code looks like this:

Private Sub ButtonClick()
' 1.

If ThisWorkbook.Sheets("3").Cells(16, 4).Value >= ThisWorkbook.Sheets("3").Cells(9, 7).Value And ThisWorkbook.Sheets("3").Cells(16, 4).Value < ThisWorkbook.Sheets("3").Cells(9, 8).Value Then
UserForm1.TextBox17.Value = ThisWorkbook.Sheets("3").Cells(9, 11).Value
Else
UserForm1.TextBox17.Value = ""
End If

' 2.

If ThisWorkbook.Sheets("3").Cells(16, 4).Value >= ThisWorkbook.Sheets("3").Cells(10, 7).Value And ThisWorkbook.Sheets("3").Cells(16, 4).Value < ThisWorkbook.Sheets("3").Cells(10, 8).Value Then
UserForm1.TextBox18.Value = ThisWorkbook.Sheets("3").Cells(10, 11).Value
Else
UserForm1.TextBox18.Value = ""
End If

' 3.

If ThisWorkbook.Sheets("3").Cells(16, 4).Value >= ThisWorkbook.Sheets("3").Cells(11, 7).Value And ThisWorkbook.Sheets("3").Cells(16, 4).Value < ThisWorkbook.Sheets("3").Cells(11, 8).Value Then
UserForm1.TextBox19.Value = ThisWorkbook.Sheets("3").Cells(11, 11).Value
Else
UserForm1.TextBox19.Value = ""
End If

' 4.

If ThisWorkbook.Sheets("3").Cells(16, 4).Value >= ThisWorkbook.Sheets("3").Cells(12, 7).Value And ThisWorkbook.Sheets("3").Cells(16, 4).Value < ThisWorkbook.Sheets("3").Cells(12, 8).Value Then
UserForm1.TextBox20.Value = ThisWorkbook.Sheets("3").Cells(12, 11).Value
Else
UserForm1.TextBox20.Value = ""
End If

' 5.

If ThisWorkbook.Sheets("3").Cells(16, 4).Value >= ThisWorkbook.Sheets("3").Cells(13, 7).Value And ThisWorkbook.Sheets("3").Cells(16, 4).Value < ThisWorkbook.Sheets("3").Cells(13, 8).Value Then
UserForm1.TextBox21.Value = ThisWorkbook.Sheets("3").Cells(13, 11).Value
Else
UserForm1.TextBox21.Value = ""
End If

' 6.

If ThisWorkbook.Sheets("3").Cells(16, 4).Value >= ThisWorkbook.Sheets("3").Cells(14, 7).Value And ThisWorkbook.Sheets("3").Cells(16, 4).Value < ThisWorkbook.Sheets("3").Cells(14, 8).Value Then
UserForm1.TextBox22.Value = ThisWorkbook.Sheets("3").Cells(14, 11).Value
Else
UserForm1.TextBox22.Value = ""
End If

' 7.

If ThisWorkbook.Sheets("3").Cells(16, 4).Value >= ThisWorkbook.Sheets("3").Cells(15, 7).Value And ThisWorkbook.Sheets("3").Cells(16, 4).Value < ThisWorkbook.Sheets("3").Cells(15, 8).Value Then
UserForm1.TextBox23.Value = ThisWorkbook.Sheets("3").Cells(15, 11).Value
Else
UserForm1.TextBox23.Value= ""
End If

End Sub

Essentially, these commands establish a condition: if the value of X (the first cell) is greater than or equal to value Y (the second cell), and if value X is also less than value Z (the third cell), then...
The value in cell G (the fourth cell) should equal the value found in P (the fifth cell, or specifically within textbox - a)
Otherwise
cell G (the fourth cell) remains empty