Search results

For the file you've attached... With your check boxes nicely arranged numerically like that, this works for me Sub ChkBoxHide() Dim i As Long For i = 11 To 40 If Range("A" & i).Value = "" Then ActiveSheet.CheckBoxes("Check Box " & i - 10).Visible = False Else...

Apparently that was just a waste of time. Good luck with your project.

This addresses only what you've asked. you 're only looping through the first 3 columns of the listbox and it needs to be 4, and your textbox names are not sequential. Try this Private Sub LB_00_Click() ' the LISTBOX For I = 0 To 3 If I < 3 Then Me("T_0" & I) = LB_00.Column(I)...

You're welcome, glad I could help.

As I understand the OP, why not store the date when the macro is run and at the beginning of the macro compare month of current date with month of stored date ? This stores to F1 to be behind the shape. Sub MoveTransX() Dim i As Long, lr As Long, lr2 As Long Dim s1 As Worksheet, s2 As...

The five Emma are spread over 3 columns. You can use Advanced Filter. Have added another sheet which holds the criteria range. You really shouldn't have blank records in your table. Private Sub TextBox1_Change() Dim crit As String, critRng As Range If Len(TextBox1.Text) = 0 Then 'required to...

Not only noticed, but expected. I believe running any macro that does anything to a sheet automatically clears the UNDO stack. I'll keep watching this thread in hopes of finding out why (or how) in post #8 p45cal indicates he was allowed to undo/redo.

This is what I found online... It's a Rick Rothstein response to a somewhat similiar question a couple years ago. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.ScreenUpdating = False Application.FindFormat.Clear Application.ReplaceFormat.Clear...

Your ComboBox4_Change calls CHECK_INPUTRFP which starts with Me.CommandButton5.Enabled = False and second to last line is Me.CommandButton5.Enabled = True

Interesting.... you write to offset(rowcounter, 7) using a loop that increments rowcounter each time, presumably to write to more rows, and your resolution clears rowcounter only. Am I missing something ?

This looks interesting... but has been posted for quite some time. Has this project advanced any? Been posted elsewhere? Been abandoned?

@ robfl22 You might want to check your cross posts for another suggested solution.

Maybe have a look at Trevor Eyre's calendar form date picker.

Not exactly what you were using but may be of use. Makes use of a user form calendar from Trevor Eyre. (Credits included with code) Simply imported his user form and module then this as the SelectionChange event. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim dte As Date...

That's quite the acquaintance you have there... http://www.mrexcel.com/forum/excel-questions/862089-getting-rid-part-formula-using-macro.html

Perhaps you are using the wrong event for what you want or perhaps you need both. Worksheet_SelectionChange applies to the cell you are going into. Worksheet_Change applies to the cell you are coming out of.

try this instead of making the sub private Sub What_Ever(Optional a As String) The macro can be called as per normal from anywhere but never shows in the Alt+F8 macro dialogue.

Works for me. Select A3 and freeze panes.

Yes, the F8 part which would have led you to your mistakes.

Right click on the command button => select assign macro => hit delete to eliminate 'DCF AND COMP VBA.xlsm'!CommandButton1_Click from the displayed Macro Name: => click OK Right click on the command button again => CommandButton1_Click will be showing in the Macro Name: => click NEW and put...