back

Hi - looking for help!! I designed an 'macro enable excel workbook' based health assessment tool a few years ago. It worked fine on versions of Excel as far back as 2003. I have just updated some of the content. A friend helped me with some coding to update a few features. He worked on it...

I have a worksheet that when a user completes they click on a button and the data is copied, pasted, and all the fields reset to blank except the DatePicker is there something I can do to call the DatePicker to reset itself back to 1/1/2019? I've been looking all over and I have found examples...

Can they be turned OFF in VBA ? So it saves a User figuring it out and only affects *this" workbook. Thanks for any help. I googled for this and found I'd asked the same thing here back in 2009 but got a not helpful reply. It would be helpful to know if they can't, and I can stop looking.

Hi I was given this macro to do back ups. I fully understand that this can be run from a specific workbook. What im trying to do is run this macro on 4 workbooks in different locations and then once all moved into "D" drive I need a subfolder creating and it ask me to name it and then move all...

Hi all I am wondering if anyone can assist with creating a formula that will come back with a 'yes' or 'no', if all conditions have been met when linked to a range of cells. In the basic example above, I want column F to come back with a 'Yes' only if the adjoining cells B-E data can all be...

My data columns have the market cap with $1.02B and $120.35M thus not allowing us to sort properly. Is there a formula or something that can be used to convert this back into numerical data so that it can be adequately sorted, we are using excel 2016 365 proplus? :confused: Thanks in advance

One of my workbooks has become corrupted, I printed all the vba, and now I have to retype it all, do I need to put each back into the modules or can I just write each sub one after each other in one module?

I have a list of names in a column.... then I have 6 columns with different disciplines..... people take part in a certain number of disciplines, I want to be able to make a combo box that will include all people that are participating in one discipline (1 column) and place their last name in...

Is there a way to tag a post to follow? In other words, it would nice to be able to refer back to see what the resolution to the issue was. Thanks!

My question has two parts to it, but I would be happy if I could just get the first part answered. The second part is mostly aesthetics. 1) Is it possible to create a link that will jump back to a previous point in an Excel document? I have a rather large document that I'm creating, and I'm...

Hi I have the following formula all over a spreadsheet <colgroup><col></colgroup><tbody> #='Week 1'!I14 #='Week 1'!J14 #='Week 1'!K14 #='Week 1'!L14 </tbody> Is there a macro that will delete the # sign on all cells that have it in and then move the rest of the data back one...

Hello, Can I get help with the code given below. I'm trying to change back color of label.:) Thanks.. Private Sub Label1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) With Application Me.Label1.BackColor = 15773696 End With End Sub

i have an excel stock trading program,,, why does this kick back an error when i have more than 99 tickers??? any help would be appreciated... https://www.dropbox.com/s/7h6u45hc1cza85q/morning%20s%26p.xlsm?dl=0

This is only my 2nd post, but the 1st one was so helpful, I'm going back to the well. I have a formula that isn't working the way I think it should: =SUM(SUMIFS(c2:c9,b2:b9,{">=6037","<=6332",4010},a2:a9,{100,101,134,136,141,355,357})) ---- How can I fix this...

Good Morning, I am attempting to count the word GREEN, (i learned my lesson on colors a while back) Seems a simple thing, guna feel dumb when this one comes back. Below are two of many attemps. (A5 is where the word GREEN is. =COUNTIF((A$10:$A$72, $B$11:$B$57), "GREEN")...

Greetings, I have a head scratcher that I am hoping you all can help me with. I am using an Excel worksheet on a 42" touch screen monitor as an information screen in our lobby. The WS is set at full screen and automatically updates with information on a regular basis, and visitors can also...

Hi all, I can't figure this out for the life of me, but I basically have a call log with many columns. The columns involved here would be column H "Request Type" and Column N "Status." I have a formula for column H where the row will highlight if the request type "Shift Swap" from a drop-down...

I am looking to create backup of the current workbook. The steps are as follows: 1. an excel file is opened 2. I am running be below code to create back up of the file 3. the file should create folder named "Export" if not already there 4. the file should create sub-folder named "Back up" in the...

Hi All, Thanks for any help on this one. I have a a number of daily logs that show a percentage toner in my cartridge. The percentage falls as i use it over time. I want to be able to see when the cartridge was replaced. But sometimes people can take the cartridge out and shake so the value...

I am working with just 2 columns. I am writing a macro to get the value from column A and put it in column B, overwriting the tag style, so that row 1 appears like the following: The Regency Straight Back is a traditional ....., and do this for all rows Column A...