Search results

oh thats very odd - as my entire data was populated in the powerpoint gantt in few seconds.

Thanks :) It worked with the + value suggestion. :) What excel version are you using? Though it shouldnt matter. Just curious. As it should not go in unlimited loop. Did you edit the data sheet with your data ? Do check the date format .... that causes a lot of issues

.TextFrame.MarginLeft = DiagramWidth * ((Cells(CurrentRow, 11).Value - Cells(CurrentRow, 10).Value) / (EndDate - startDate)) * 1.2 Not sure why it is going in endless loop as it works fine on my machine :(

okay thanks .Textframe.MarginLeft = Width *1.1 The code crashed with an error - after getting the text fixed on the bar. so it worked on the bar and when it reached the milestone it crashed.

The point was to use Excel data to create a Powerpoint gantt (via code) to send to leadership. How does one determine the length of the bar ? Because i tried margin left etc. nothing worked

The whole code worked except of the text on the bar

Attaching my workbook

I added >>> use code - tags <<< TextFrame2.MarginLeft = RowHeight * ShapeSize *3 The smaller gantt chart bars it worked fine. But for Larger bars it doesnt work...

The below code is executed after the shape (Gantt chart bar is created) to update the text (Task description).... The output is that from the left margin of the bar the task description is populated... But i would like to have the task description tagged after the bar is ended. I am attaching...

Apologies to all who helped me on this - Next time onwards will ensure i provide the exact spreadsheet with the problem statement.

Thanks - it is not working getting Subscript out of range :( But if i change -2 to -1 it worked.

Uploaded how the file looks like

Updated random data

The test macro is picking Row 1 and NOT Row 2 in my workbook. :(

Let me check the spreadsheet - Still issues with 224 sheets - It says Subscript out of range

224 sheets excluding the 2 sheets (List and Output).

THanks, It is showing blank rows for Sheet10 in the Output Sheet post macro execution And it gave me subscript out of range for b(i) as there are 224 sheets to process

Have a small bug - the current Region copy copied my entire data in the sheet not only the 2nd row all columns. Can you please help? ws.Range("A2").CurrentRegion.Copy (Copied all data from A2 below till the data exists in the sheet). Require only to copy A2 to Last column in Row 2.

Hi All, I have multiple sheet - having data in Row 2 starting from A2 until some columns (some sheets have data till D, some have data till G etc..) I would like a macro, which would copy the data of Row 2 (All columns having data) from all sheets and paste it transformed in Column A in Sheet...

Check this file - with values in each sheet (output) after the process button is clicked. Form II where the Process button is - would be the place where the values need to be selected and then once process button is clicked the 3 sheets to be populated. Requirement #2 The user would select ...

i am not able to understand your questions... If you refer my last attachment i have given real sample values in the sheets that need to be populated using the Process button on the Form II sheet. The template i have attached is the final layout and working model i would like to achieve. I...

Requirement #2 The user would select : 1) Feature : Data Sourcing 2) Components : Multiselect values from Listbox - Values that would be selected are : Feed File - Existing (Enhanced), Adjustments - Concise Template and Table & Views - This values would appear in the list once the Requirement#1...

I am going to split the request to ensure step by step VBA code for the same. Requirement#1 Form II Sheet has a ListBox for Components Based on the Feature Selected it should populate the corresponding values from Global Config sheet (Feature-Component Table) into the list box on Form II Sheet.

i shall populate the results in the spreadsheet and re-attach by tomorrow but the functioning is way the permutation combination and selection works is not by select values per parameters and put all in the table. Components depends on Features and Locations depend on Role and the selections...

The logic is not that simple - as the sample file does a permutation & combination of all respective values per feature, component etc. generically based on selection. The template i have attached latest is what i see as the final requirement of it to be working and with the right set of...