# Posts by h

• ## Check If Sheet Is Active

Re: Check If Sheet Is Active

Code
``````Sub t()

If Sheet1.Name = ActiveSheet.Name Then Exit Sub``````

Thank you

• ## Check If Sheet Is Active

Re: Check If Sheet Is Active

Yes Dave, i am in sheet1......
while i move between sheets a code is excuting, so i need the code to check if i am in sheet1 then exit the code but if i am in other sheet then the code complet the excution.

That's why i need to check if sheet1 is active or not ?

I trid to apply the code given by iwrk4dedbr, but donot know how to use it , pls help?

• ## Check If Sheet Is Active

Hi there

I am in sheet1 , Is there a code to check if the sheet 1 is active or not ?

Thank you

• ## Dynamic Sum Formula / Function

Re: Dynamic Sum Formula / Function

Ok,Dave

I used a named Range = Sum(therange)

• ## Dynamic Sum Formula / Function

Re: Auto Accumelate Formula

thank you

i mean when i enter a number after A100, i need the formula to add it ?[hr]*[/hr] Auto Merged Post;[dl]*[/dl]I got it done

thank you for the spent time

• ## Dynamic Sum Formula / Function

Hi there

I use this formula = Sum (A2:A100), and it works.

I would lke to use a formula located in A1 to auto add each number i entered within the range A2.....A100

Thank you

• ## Error: Argument Not Optional Calling UserForm

Re: Error Calling Userform

yes, you are right

• ## Error: Argument Not Optional Calling UserForm

Re: Error Calling Userform

yes, all your comment are in correct order

but still the error appears ?

• ## Error: Argument Not Optional Calling UserForm

Re: Error Calling Userform

it is not shown, when i call the sub menu macro, this error just fired out without showing which line cuses the error.

• ## Error: Argument Not Optional Calling UserForm

Hi there

I call a userform from a sub menu i created it, but i got an error 449:
Argument not optional.

• ## Highlight Value Inside Textbox

Re: Highlight Value Inside Textbox

• ## Highlight Value Inside Textbox

Hi there

When I use TextBox.SetFocus in a userform , the curser will be inside the TextBox,
My TesxtBox has a value in it, so when i apply the TextBox.SetFocus I want the value to be highlighted insted of only being the active TesxBox.

Thank you

• ## Add Combo Box Item To List Box

Re: Add Combo Box Item To List Box

Thank you Dave

I looked at the LBound UBound in the VBA help. I understand them.

Is there an Excel file explains their usage in VBA programming windows can be bought ?

• ## Add Combo Box Item To List Box

Re: Loop Checking Items Name In Listbox

Thanks a lot

It woked Fine

Could you please send me a link that explain with examples the usage of LBound and UBound ?

Thank u

• ## Add Combo Box Item To List Box

Re: Loop Checking Items Name In Listbox

Code
``````For i = LBound(ListBox1.List) To UBound(ListBox1.List)
this line gives:
Run Time Error 13:
Type mismatch``````

donot know why ?

• ## Delete Without Triggering Change Event

Re: Delete Without Triggering Change Event

Thank you all very much

• ## Add Combo Box Item To List Box

Hi there
I use ComboBox to add items to the ListBox in userform
I am tring to loop through the ListBox to check each name in the ListBox, so ifthe name chosen by the ComboBox exists in the ListBox then donot add it,
but both codes do check the number of the item in the ListBox.
I need to check the name of the item. ?

Thank you for help

• ## Delete Without Triggering Change Event

Re: Press Delete Without Trigering An Event

Thank you very much
both ways worked fine

• ## Delete Without Triggering Change Event

Hi there

when I press Delete a value within a Target Range in a sheet, the sheet event is trigered.
how can I press Delete a value within the Target Range without the event being trigered ?

Thank you

• ## Force Focus To Range From Modeless UserForm

Re: Force Focus To Range From Modeless UserForm

Thanks Dave

The value of the ShowModal Property of the UserForm was set to True , so i changed to False and it worked fine.

Thank you