Posts by guerilla

Re: Yes No Dropdown Menu

Quote from Miffo

I would think the easiest way to do that would be to create a validation.
Just write Yes and No in two diffrent cells, selectect them and give the list a name (in the top right corner, just above the columnletters).
Then you just select the cell you want the drop-don list to be places, go to DATA - VALIDATION and in the list you chose List.
In the Souce-field you write in the name of the list you just created (and dont forgoet the = before the listname).

After that, every time you select that cell, you'll get a dropdown list with Yes and No.
Its easy to handle in code, since the choise will be the lists value.
Ex:

Code

If Cells(1,1).Value = "Yes" then
  'do what you want if they chose yes
else
  'do what you want if they chose no
end if

Display More

Aha, i found it in the top left side, thanks for your help : D

Re: Yes No Dropdown Menu

Thank you for your reply Miffo, unfortunately i cannot see where to give the list a name. There is nothing above my column letters. at the top right. :s

I need to put a Yes No dropdown on my excel sheet, any ideas?
Thanks

Re: Rename Worksheet Code

ok, no problem, all sorted now, thanks for all the help.

Re: Rename Worksheet Code

thanks for the quick reply, i really am a beginner here and I'm still having trouble getting this to work.

ThisWorkbook.Sheets(1) //from 2nd post to select the sheet
ThisWorkbook.Sheets("Sheet1").Name = "Your new name" //from 3rd post to rename this sheet

on the first line should i include .select at the end?

Re: Rename Worksheet Code

thanks for the replies, I'm a bit of a newcomer to macros so please bear with me, at the moment my script is looking like this

Sheets("old report name that is different everytime").Select
         Sheets("old report name that is different everytime").Name = "new report name"

What I'm trying to do is have my macro change the worksheet name to a generic name, i.e. report so that the rest of the macro will work. thanks again

Hi, I need a little help with my macro. I currently download a report and it has a different worksheet name everytime. Is there any way using a macro to change the worksheet name? (My macro extracts data from worksheet a and copies into worksheet b) Hope I've provided enough info. Thanks for all replies