Search results

yes, that should be absolutely fine with me. Thanks once again. Regards.

Dear Narayan, This is the test file as requested. https://www.dropbox.com/s/bfqrgkulmbhs4un/Combo%20Box.xlsx Please keep me posted if you were able to open the file from the above link, else let me know if there is any other way i can share the file. Regards.

Dear Narayan, Thank you for the suggestion of radio button for the first option of the user to select. however, my question is actually for the second one where the listfillrange option should pick the named range of cells information which isnt populating. Thanks in advance. Regards.

Dear Kaushik and SirJB7, Thank you for the links. What I'm trying to do is a little different. Since the list data is huge I want to give an option to users to type first characters to choose from the list and for this I want to use Combo Box. I was successful using a named range which I had...

Hi, Probably this would be very simple but I'm not sure how to populate this one. There are two combobox in a sheet. The first combobox has a dropdown of named cells and the second combobox should list those named cells based on the user input in the first combobox. Not sure how to do this. I...

Thanks Luke. That worked :) Have a nice day...!

Not sure how to do this. Columns A B C D E F G H [Blank] [Blank] Header Months Date units update Comments The form should do this. 1. User should be able to select month from the drop-down (I've already placed content) 2. Based...

works like dream....thanks once again Luke for getting it work again :)

Thanks Luke, I just did a few changes to the code that you gave but after changing the codes it gives me a msgbox but its blank with a OK button. would you know why? this is what i tried. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1:A10")) Is Nothing Then...

Wow...that worked :) Thanks once again Luke Have a nice weekend!

hey...thanks luke. The code works but after selecting the data and revisiting the cell otherwise the msgbox does not pop up. could lemme know why? best regards!

I'm not sure how to but this is what I intend to have, if my selection is LA msgbox should state "enter details", if my selection is CA msgbox should state "enter details", if my selection is "others" msgbox should state "please try again", if cell is blank there should not be a msgbox prompt...

that worked, like magic. Thank you so much :) Regards....A!

Sorry forgot to include the link of the file. Here is the link for your refrence. https://docs.google.com/spreadsheet/ccc?key=0AgqXxSvYwRm8dHRJRzJ6VVRqbEtYdkNMYkhrdk91THc regards...A!

Hi, I'm trying to populate working days between start date and end date. For example, column A has start date as 07/06/2012 and column B has end date as 25/08/2012. I should get my start month as june and the number of working days from 7th june to end of june and the following columns should...