Search results

Hi James, you can do this by adding the Datetime(=Now) comments to each cell (Column with Names etc.,) you edit in the workbook. Everytime you edit a cell, the comment gets updated with the current datetime. Have a button or a routine to run periodically when you want to check the cells and...

Hi, Here is another way without VBA. 1) Place the workbook with only your Mainsheet/any other sheets required along with Main at your userprofile\Microsoft\Templates folder(%appdata%\Roaming\Microsoft\Templates) in Windows 7. 2) Right click on the sheet tab -> Insert and you will have your...

Supriya, A file upload is always a better option to get more and accurate response. Upload a sample file, if you cant get the complete file here.

OK.. cool. You can use the above function, in case if you dont want to go by VBA way. Thanks.

Hi Suresh, Here is a way. 1) Place your cursor on cell D3 and go into the Define Name (Formulas -> Define Name/Name Manager) 2) Ener Name as "CRDR" (of your choice if you want) and under "Refers to" enter this formula =Get.cell(7,!C3) 3) On Cell D3, enter =CRDR, this should display the...

OK.. Here you go.. Thanks to the previous posts on the web with slightly modified to your requirements. =MID(A1,SEARCH("Z",A1,1)+1,SEARCH("^^",SUBSTITUTE(A1,"-","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))))-SEARCH("Z",A1,1)-1) Just make sure that you do not have "^^" character repeated...

Hi Smittal, I doubt, you can do this with the Inputbox unless if there is anyway with the API functions .Otherwise, you can create a Userform with a textbox on it and set the PasswordChar property of the text box to asterisk (*).

Hi Jovica, Check if the below options are enabled in your Excel. 1) File -> Options -> Advanced -> Under "When Calculating this workbook" section, tick the option "Save External link values" & "Update links to other documents" 2) File -> Options -> Advanced -> Under "General" section. tick...

Hi Lymm, Change your line of code to this. But, there are better ways to do this job. Sub HideRows() Dim cell As Range For Each cell In Range("A2:Q150") If cell.Value = "Culled" Then cell.EntireRow.Hidden = True 'cell.EntireRow.Hidden = cell.Value = "Culled" Next cell End Sub

Hi Jams, Smallman's approach with Pivot table is always easy and fastest way. In case, if you do not want to use the Pivot table(very unlikely) then you can follow this method. 1) Extract the unique CATNO list into another column (Advanced filter -> Unique records only). Say you have these...

Hi, Are you using excel 2010? I experienced the file link issues in past and what I have found out was that to install latest hotfix for office version. There were some file link issues with the office products initially and later hotfixes helped to resolve those. Not sure if you are running...

Hi Jeffrey, Here it is. Give a try and let me know, if you need any further change. I am leaving office now and would be able to check this back at home. Private Sub Worksheet_Change(ByVal Target As Range) 'FOR COLUMNS "B" through "I" ' each time "YES" selected in rows...

Hi Mark, I cannot upload the file from my PC here, but here is how you can do following the example in the link you provided. 1) Copy and paste the Indicator table(Gv, GV+, End) at another cell . You have 2 indicator tables now. 2) Copy and paste the Pie chart you created out of the first...

Hi jeffrey, Replace the below line of code where you compare the target text and the KsTrigger. This should do the comparison correctly and gets into the loop. If LCase(.Text) = LCase(ksTrigger) Then With Target If LCase(.Text) = LCase(ksTrigger) Then lookup_array = Array(0...

Hi Jediantman, Try this : =IF(ISNUMBER(SEARCH("S5",D4,1)),IF(OR(ISBLANK(H4),H4=""),"",WORKDAY(H4,1,holidays)))

Thanks Vijay for sharing such a informative link. Following the footsteps on the link, I am able to find a custom format for this issue. Sanjeev, Format your cells with the custom format 0.0###,,,<ctrl J>%% (Press Ctrl+J on the format cells) and set "Wrap Text" option also. This should display...

Hi Jams, Use a helper column (insert a column between A and B) and add the below formula on B3 and B4 Cells. =SUBSTITUTE(C3,CHAR(10),"") &CHAR(10) &SUBSTITUTE(D3,CHAR(10),"") &CHAR(10) &SUBSTITUTE(E3,CHAR(10),"") =SUBSTITUTE(C4,CHAR(10),"") &CHAR(10) &SUBSTITUTE(D4,CHAR(10),"") &CHAR(10)...

Hi Jeffrey, In first place, I still do not understand the logic behind having so many comboboxes. You could have easily achieved the same by using datavalidation since the values displayed are only "YES" & "NO". It makes a difference in the file size when you have activex objects on the...

Hi Jeffrey, Its the code in your "ThisWorkbook" module emptying the comboboxes text. Comment out the below line from your code. '.OLEObjects(i).Object.Text = "" Here is how it should be on "ThisWorkbook" module. Dim objControl() As ClsComboBox Private Sub Workbook_Open() Dim obj_num As...

Thanks Narayan, I referred the link Sam has posted and it seems the issue is only with Excel 2010. Also, is this because theoretically Superscripts appear at the end of the text and Excel is understanding it to Autocorrect?

Sam, Thanks for this but still no luck as it is changing the character font property for all the datalabels. I am using Excel 2010.

Thanks Narayan, Though its not me who raised this issue but Sifar, I am really interested to see how to get this issue down.

Hi Suresh, Glad it solved your issue.

Hi Narayan, I am using Excel 2010 and it changes the other datalabels when you try to modify the 3rd datalabel onwards. Would you please spend sometime on the coding of the file and see what's causing this. I am not able to figure out whether its an Excel issue or something wrong with the way...

Hi Venugopal, 1) Check if there are any disabled items in your Excel (Options -> Addins-> Choose disabled items from dropdown -> Go.) Enable all the items. Also check the Com-Addins section and remove the references if there are any. 2) Delete all the *.exd & other files from the Forms folder...