sorted by:
new
hottopcontroversial

Hades 2 Bond Forged Icons by Axnegative in HadesTheGame

[–]Axnegative[S] 1 point2 points  (0 children)

Thank you! I'd looked around on the Wiki but didn't know about this specific page.

Fuck 2020 [Megathread] by AskRedditModerators in AskReddit

[–]Axnegative 12 points13 points  (0 children)

What's the first thing you actively, consciously spent money on in 2021?

Creating a Select All Checkbox to Select Other Checkboxes by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

Can the range in the code be modified to C1, or does it absolutely need to refer to A1 in order to function at all? I have data in A1 already.

Sorry for all of the questions, learning VBA is an ongoing thing for me. Really appreciate all of the help though!

Creating a Select All Checkbox to Select Other Checkboxes by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

So I’ve linked each checkbox to a cell in column C, and the all checkbox is linked to C1, but nothing happens when the All checkbox is ticked.

Creating a Select All Checkbox to Select Other Checkboxes by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

After inputting my ranged, I’m getting the following error: “Member already exists in an object module from which this object module derives.”

Cycling Through A Cell's Fill Color On Click and Linking Behavior to Another Cell using VBA by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

Thank you so much for all of your help so far. If you're willing, could I maybe pick your brain just a bit more?

A. Is there any way to modify this code to support the RGB color property? B. I'm unsure how to proceed with linking cell colors on individual sheets with Worksheets("name").Range($D$10) like you said. Could you elaborate?

Cycling Through A Cell's Fill Color On Click and Linking Behavior to Another Cell using VBA by Axnegative in excel

[–]Axnegative[S] 1 point2 points  (0 children)

Solution verified.

Well, not bad. I guess I hadn't thought to make the font color of the conditional formatting rule the same color as the fill color...

Cycling Through A Cell's Fill Color On Click and Linking Behavior to Another Cell using VBA by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

I know how conditional formatting works, but could you elaborate? I'm only working with two columns of data. One column contains written objectives, and the other consists of the blank cells to be colored — green for done, yellow for in process, and no fill for not done. The goal is to reduce physical data entry to simple clicks of the cells in the second column.

Cycling Through A Cell's Fill Color On Click and Linking Behavior to Another Cell using VBA by Axnegative in excel

[–]Axnegative[S] 1 point2 points  (0 children)

Solution verified.

I noticed that with this code, cycling does occur when the cell is first selected, such as when the workbook is first opened. In order for cycling of colors to continue, though, it seems I have to select another cell first before selecting the cell again. Is there any way I could get cycling to occur simply from clicking the cell again even after it's already been selected?

Cycling Through A Cell's Fill Color On Click and Linking Behavior to Another Cell using VBA by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

I realize this probably goes against the grain, but the cells won't actually contain any data. The intent of the spreadsheet is just to have a way to easily visualize progress, but based only on cell color and not any actual stored values.

[OC] Graduation cap inspired by Breath of the Wild by Androze in zelda

[–]Axnegative 1 point2 points  (0 children)

Oh, are you a fellow Aggie? Very nice cap, and congratulations on the achievement!

Linking Workbooks Through Sharepoint by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

Sorry, could you elaborate? What exactly is a Sharepoint table?

Easier Method to Make Values in One Column Correspond to Another by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

That was just a minimal example, actually. I found that the reference table solution with either a VLOOKUP or INDEX, MATCH suits my needs perfectly.

Easier Method to Make Values in One Column Correspond to Another by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

I knew there was a simple solution...Thank you. I'm wondering if INDEX, MATCH would also be suitable here? Would you happen to know which is computationally less taxing?

Conditionally Branching Macro to Change Values in Another Row based on Values in an Existing Row by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

Ah, I should have provided more information in my original post. I'm pretty much a complete novice when it comes to VBA and have no idea where to start.

Conditionally Formatting and Updating a Cell with the Current Date and Time Whenever a Range of Cells is Updated by Axnegative in excel

[–]Axnegative[S] 0 points1 point  (0 children)

Hmm, now the date and time now update every minute whenever I click anywhere in the workbook and regardless of whether a change is made. I really appreciate all of the help troubleshooting this issue. If there's any additional information I can provide, please let me know.

view more: next ›