Posts by Brenda Lee2

How can we type a checkmark directly into an Access or Excel checkbox using just the keyboard? I want to skip the mouse entirely. Is there a way to actually input that green checkmark symbol into the box?

Kyle Johnson2 said:Let’s say the number you want to change is sitting in cell A1. In that case, copy this macro into that specific Sheet

Code:

Sub plus()
Application.EnableCancelKey = xlDisabled
Application.ScreenUpdating = False
Range("A1") = Range("A1").Value + 1
End Sub
Sub minus()
Application.EnableCancelKey = xlDisabled
Application.ScreenUpdating = False
Range("A1") = Range("A1").Value - 1
End Sub

On the sheet itself, just set up two buttons—one for plus and one for minus.
For instance, check out the screenshots at the link, and I’ve also included a downloadable example here.

Can you walk me through the whole process in more detail? Something isn't clicking for me.

Is it actually possible to do something like this in Microsoft Excel? Let's say I have the number "352" sitting in a cell, and I want to be able to hit a plus button to bump that number up, or a minus button to dial it back down. If that specific setup isn't doable, can we at least get something close to it?

Kyle Johnson2 said:Pair your IF function with an OR function to make things easier.

For example: =IF(OR(A1=5,A1=10,A1=15,A1=20,A1=25,A1=30),"YES"," ")—you can just keep going until you hit 30 arguments if you really want to.

Thanks.

I need some help troubleshooting this formula. Right now, I'm using =IF(D26=15;"JUB";" "). It works perfectly fine when I'm just checking for a single specific value—like the number 15 in this instance—but that’s not what I actually need. How do I write a formula that handles a whole series of inputs? Specifically, if I have to enter numbers like 5, 10, 15, 20, 25, 30, or 35, how does that work? Basically, if I type anything from 1 to 4, it should stay blank. If I type 6 through 9, it stays blank, and so on. How do I structure this logic?

I’m running into a frustrating issue in Microsoft Word. When I try to copy a specific block of text—let’s say "FIRST NAME LAST NAME" (set in size 12 Calibri with a red background)—and hit copy, the paste function completely strips everything away. It just gives me the plain "FIRST NAME LAST NAME" without any of the formatting inside the parentheses. To make matters worse, that little little icon that usually pops up after pasting to show you the paste options? It’s nowhere to be found. Should I be looking for a way to toggle that back on in the settings? I actually went to the Microsoft Office help section to troubleshoot this myself. They gave me the standard, textbook answer: go to the OFFICE tab, hit WORD OPTIONS, navigate to ADVANCED, and then check the settings for PASTING WITHIN THE SAME DOCUMENT. Well, guess what? I’ve already checked all those boxes, everything is set exactly how it should be, and yet it still refuses to work. Is there any other logical explanation for this? Or am I just fighting with the software for nothing?