Search results

Chihiro. Apologies for the confusion that i have created. you went out all the way to help me. i can see the result that i wanted. Thanks a ton.

not sure if this is too late. i have attached the file. command button on sheet 2. count the number of times student ids appeared on sheet1. result should pop across each id on sheet 2. A straight countif would have been so easy but i am just trying to learn arrays so i want to declare a range...

actually it is a part of the code that i am writing. so i am just trying to check how it can be done. so i declare range as an array and if i am checking how many time these values are updated in the next sheet. lets assume staff id 26001005 appeared 10 time in sheet1. so the number 10 will be...

Hi All i have sheet1 and sheet2 . column "B" in sheet 2 has staff ids (ex 26001004,26001005.. and so on) lets say some 20 ids These ids are repeated in sheet 1 column "B". i am trying to write a VBA code. Need suggestions how can i declare range "B" in sheet 2 as an array and count the...

Very true. I totally get that as u say depends on what and how. Thank you once again for help

Thank you ajesh . one last question. is it a best practice to use a boolean variable in every for loop/ loops so that we are telling the code what do when found the value and when not found the value.

Ajesh could you tel me regarding the Boolean variable and Exit for in this context what they are actually checking and how does it fit in the code. i marked my questions also in the code as comments. Many Thanx

Thanks ajaesh. it worked

Thanks ajesh for your time and reply. i am just working with the solution you have provided will just get back to you.

Hi All I am working on two files the master file and source file The source file has information about volumes but only 100 rows with 3 column Staff id queuename volumes 16001005 process A 99 16001005 process B 101 16001006 Process A 200 The master file has information...

Hi All Can we insert hyperlink in to a textbox . My text box is on a sheet. Example text1box.value = "https://google.com" is there a code on the lines of follow hyperlinks..... Many thanx

Just to refine my question further. for example on a yahoo / google website there are different documents saved in a word format out of which i want to open "travel details" document only. I have a commond button on my excel sheet called "travel" so what i wanted is once i click the button...

The word documents are saved on a particular weblink (ex:http//abc.com/...) once i click the link there are 20 different word documents. My command button on the excel sheet will have the name of a word document. so once the user clicks that particular document should open. In case further...

Hello All I am creating a excel document with Command button to open a particular document from a particular link. The link has some 20-30 documents on the page. Any help ideas how to solve the issue I was able to open the link by doing the below code if the file is on the desktop or paths...

this is not working. it quits since error resume next. but there is a file on abc.xls on my desktop. the code i have applied on a command button in a diffrent workbook t1.xls. did i miss something here

Thank you yaseer. how to do this for a non active workbook. say i am working on file abc.xls while i am trying to search file def.xls / ghi.xls so if the user types filename in a inputbox can a message pop giving us the path

Hi All Is it possible to know the file paths through "Thisworkbook.path" or any other option in vba Actually I am trying to know the paths of certain files present in various folders (few files are on desktop, some are in c / dates /.... and so on ). I have tried doing it...

*** Thank you very much yaseer. Appreciate for your timely help.

Hi All I have a sheet with some values in a column. example 5 diffrent number in column G I want to copy those values and copy them between the empty rows between those numbers 1st number is 12345 and there are 10 rows empty after that in the same column i want to copy 12345 in the next 10...

Hi All I have a file where sheet 1 has weekly targets. and sheet 2 has targets+actuals day wise. All i want to do is copy targets day wise in to sheet 2. please note Few lines of where msg box is written is only to check the progress of the code this might be irrevalant when you are going...

i could solve my prob with the code below Dim pc As Variant pc = InputBox("enter your choice") Select Case pc Case "AB", "DE", "FG", "DE", "GF" MsgBox 1234 Case 12, 23, 45, 77, 99, 25, 66 MsgBox "ABCD" End Select

I have 20 -30 choices. user enters one of them in the input box example "AB" / CD" / "EF". Based on the input it will give a particular message

Hi All The user inputs a value and based on that there is some action like diffrent message boxes for different input values Want to know if there is any simple way to write the below code. I have more than twenty such choices like "AB", "BC"......................... and so on. Even in...

Thank you Asheesh

I am selecting a value in the combo box and doing a vlookup for 3 column. The value in the combobox is in Text format. Example value selected in a combo box is "New York" the value in its column 3 is some 200 /300. so it should show this value. I know vlookup has some issues while...