format

I have 3 text boxes, accompanied by 3 spinbuttons. spinbuttons put day, month, year into the text boxes. When I enter the values into a cell, it's not in a date format. How do I convert it to a date in vba? Here's the code I used. Private Sub SpinButton1_Change() If Me.SpinButton1.Value = 0...

I'm building Pie Charts for a client at work and they are asking me to try and remove the Gray Line that goes through the middle of my Pie Charts. I've included the data set for reference. As you can see, only the 'Lab' User Group has any value in the SF column. Despite only the 'Lab' User...

Hi, all, I have a userform with 5 input fields, four of which are textboxes (the other is a combobox). Two of the fields ask the user to input a date in the format dd/mm/yy, and one of them asks for a number. Currently, these values are added to the worksheet as text values, even though the...

Hi Guys, Columns B, C, D, and E contain a list look-up (Yes or No) Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!) I placed the updated functionality in column F. Then I wanted the user to identify the scope of work based on the...

Hi, I am hoping someone could assist me please. I am helping someone with a spreadsheet and they are wanting to flag dates at various stages. Essentially they are looking for two queries; - When 10 business days have passed column P (Closing date), column W (Selection Report finalised) will...

I created a userform that displays certain values within row of the active cell, as a quick reference in a lofty spreadsheet. Right now it shows all values as regular numbers (shows "1" instead of "100%"), even if the referenced cell is a percentage. Code below --- i want Label9 to show up as a...

Hi, I have a spreadsheet that will be used by other people and I have locked all the cells which contain formulae and conditional formatting so that no one can break my sheet. However, there are some columns which the user will free type into and they would like to be able to change the colour...

Having trouble isolating the time component from some .csv data I'm importing. The datetime comes in as dd-mmm-yyyy hh:mm:ss:000 format, I ran a replace to repair the colon separator between seconds and milliseconds. Now I just want the hh:mm:ss.000 component. I tried to simply reformat with a...

Hi Everyone :) I am experiencing an issue with a macro I created to help format some raw data sheets I have to deal with at work. The macro I have made is almost perfect, except I need the macro to detect the data range of the cells in use (as this changes with each RAW data file I receive) and...

I'm looking to make cell range C9:C56 the only cells on the sheet where I can allow users to format the cell while protected and be able to change the cell colors in that range only to their liking. So far, with the given code below, all cells on the sheet are formattable while protected. From...

Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...

Hey guys, this forum has been super helpful for me in the past so I registered to ask a question I'm not able to figure out on my own rn. I work for a credit card processor and need help formatting expiration dates for use in a gateway that requires them in a specific format. The original info...

Hi all, I have a problem with textboxes in userform. Basically i just want to display one cell with a timer inside through one textbox in my userform. In C2 i have a timer and the cell format is "mm:ss", so the textbox2 should display that cell in that format but it seems so complicate. If the...

I think this is a formatting question ( or could be something else and I'm just not seeing it). I'd like to display data as 1/x. So the numerator is always 1 and the denominator changes. For example: 200/ 1000 = 1/5 2/5 = 1/10 330,000/330,000,000 = 1/1,000 403,000/330,000,000 = 1/819 Thank...

Hello, I have a worksheet that contains a parent product in column A, a Catagory in column B, and part numbers in column C, and again in column D. The goal is to combine all part numbers in column C and D. Normally I would find and replace all " " with "," followed by a =CONCATENATE(C2,",",D2)...

I have seen similar questions asked but have yet to find an answer for my circumstance. I have a Name Range (CDate) where a date is manually inputted into an excel file. I was using that name range in a formula to see if I should hide or show a column header. They are name ranges as well and are...

Hello I am having a problem formatting data in excel, I am preparing this data to import into a database that i have created. the problem is as follows: the raw data i have is for multiple chocolate recipe's that are broken down into the following: Name of recipe weight of ingredients unit of...

Hello Excel Gurus! How can I format an Excel TimeDate from a double to mm/dd/yyyy hh:mm:ss.000 Thank you! Please call this sub to demonstrate my question: Public Sub TimeWithMS() Dim Timestamp As Variant Timestamp = Evaluate("Now()") Debug.Print Tab(0); "Timestamp:"; Tab(15); Timestamp...

Hi, this may seem a basic question but I really cannot figure out how, would appreciate some help I’m training to be a business analyst and have a table with 30 leads in column A then B is 01/01/2020 and the corresponding cells are filled to show how many leads we’re getting from each lead...

Hey guys, I guess I'm just being dense because this doesn't seem like something too difficult, but I'm hitting brick walls at all of my ideas. So I have text numbers pulled from our database and when they pull the data there is not '.' where there should be for normal dollars and to be able to...