Search results

Hi Marc L, Interesting demo. It demonstrates there is a solution to my problems. I'm looking further. Regards

Hi the forum, First of all, I would like to wish everyone a happy 2017 I try to solve the following two problems. I have two files, an Excel one and a Word document. The Word document contents some text referenced by bookmarks. The Excel file has one sheet containing a combobox and a...

Fantastic ...and so simple I enjoy Harry

Thanks for the explanations. Have a nice day Harry

Hi Narayank, Many thanks for your solution. But, could you be so kindly to explain the use of the MOD function in this case. And, by the way, how can I highlight the today's date on the chart. Harry

Hi Narayan, thanks for reacting. I uploaded a test file Harry

Hi the forum, I want to create a chart with dates in horizontal axis and hours in vertical axis. I have two columns showing by date col1) the time of sunrise (col2). The two columns have the same content with a different format. For dates: dd-mm-yyyy h:mm:ss displayed as dd-mm-yyyy For hours...

Hi Debaser, Thanks for your answer. Your solution is running fine. Have a nice day Harry

Hi the forum, I want to submit the forum the following problem: In a VBA procedure, I feed an array variable (Dim Temp_Max () As Variant, ReDim Temp_Max(200)) with temperatures (numeric values): the_temps_Max(i_temp) = Worksheets("DATA").Cells(x, 4).Value Same reasoning with years...

Hi Debaser, Thanks for your answer. I didn't know thie properties. Have a nice day Harry

Hi the forum, In a procedure, I compute the monthly average of temperature between the years 1833 and 2015. Everything goes fine until 12/31/1929. When switching to 01/01/1930, 1930 becomes 30 and is considered as being less than 1900. Below you will find in the pictures the values in the...

Hi sidxl, Assuming you created, in the sheet that contains the data, two activeX buttons which names (not the caption) are btn_Tot_Today and btn_Tot_Between, replace the existing code by this one. Even if you change the name of the worksheet, the code remains operational. Harry Private Sub...

Hi VarunMV, Assuming the raw text is in A1 the required words in A2 the formula in A3 should be =MID(A1;FIND(A2;A1);LEN(A2)) Hope this help Harry

and this one Sub sumbetwdate() Dim ws As Worksheet, lastrow As Long, rng As Range, tot As Long Dim D_Begin As Date Dim D_End As Date D_Begin = InputBox("Date begin") D_End = InputBox("Date end") Set ws = Worksheets("sheet1") ws.Activate lastrow = ws.Cells(1, 1).End(xlDown).Row For Each rng In...

Hi sidxl, try this as procedure in sheet1 Sub cond_sum() Dim ws As Worksheet, lastrow As Long, myrange As Range, rng As Range, tot As Long Set ws = Worksheets("sheet1") ws.Activate lastrow = ws.Cells(1, 1).End(xlDown).Row For Each rng In Range("A2", Cells(lastrow, 1)) If rng <= Now() Then...

Hello the forum, I wrote a small application to manage cascading dropdowns. It uses the technique of "scripting dictionary." As you can see in the attached file, in the "cbx_countries_change" procedure, I use a classical comparison to select the "items" because I do not understand the...

Hi p45cal, Thanks a lot. That was exactly what I was looking for. The improved code is also significant. Have a nice day Harry

Hi p45cal, Thanks for your answer. I guess, if the number of events (or test) for a participant is less than the number of events than should his name be written in italic. But technically, i'm not able to translate it in VBA. You will find an example workbook in attachment. Are more information...

Hi the forum, I try to write a VBA application to analyze the results of the participants in several events. As you can see on the picture in attachment, some participants do not complete all events. Based on the pivot table, a pivot chart is build. The name of the participants who do not...

Hi Chihiro, I found the solution for my pivot chart. Sub btn_SwitchR_C_click() If ActiveChart.PlotBy = xlColumns Then ActiveChart.PlotBy = xlRows ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Text = Worksheets("PiTa").PivotTables("PtRes").RowRange.PivotField.Name...

Hi Chihiro, Thanks for your answer. Your solution don't solve the problem. When changing the name with your code, the category title is well adapted but remains when I switch the Row/column again. I think the category name must be found in the PivotTable but I don't know how. Regards, Harry

I forgot to upload the file

Hi the forum, I’m facing with the following problem. How can I, in VBA, change the category label when, in a pivotchart, I switch the Row/Column? As illustration, in the attached file, select a “team” in the Team worksheet. A pivotchart is shown. In the pivotchart sheet, a click on the...

Thank you for the clarification. During the weekend, I somewhat improved the application based on the philosophy of your solution. I did not consider the possibility of drop-down lists to choose the participants because the pivotchart has a choice function. However I’m facing with another...

Hi Luc M, Hello to the other stakeholders When I read your solution, two words came to my mind: congratulation and thank you. It is also a beautiful application of the adage before thinking VBA, think Excel Your solution is not only original but she also proves an in-depth knowledge of...