Search results

Hi Sifar, I tried my best to figure this out, but seems to be a bug with Excel. Its the third datalabel onwards which acts weird and change the other datalabels font as well. Its not only through VBA programming but this happens even if manually change the font settings. Will this help you...

Excel shortcut: Select any object and press Ctrl + Shift + Spacebar to select all the objects in the sheet.

Hi Smittal, Option Explicit forces you to declare all the variables you have in your module/form/any other VBA object. Please refer below link for the details. As far as your issue is concerned, if you could get me a sample of what needs to be copied from the files under the subfolders to your...

Hi Smittal, This is very much possible, if you have the folder/sub-floders named exactly as what you have on the data validation. Please refer to the below link, which is similar to your issue. You can copy and tweak the code in the link and post here if you get stuck somewhere ...

Thanks bobhc. I will put my questions on those forums as well. SirJB7, I am currently working with some automations on Excel through VB.net. When it comes to deployment, VBA always had a upper hand to wrap everything in the EXCEL file and distribute the file to anywhere, anytime. Since the...

Hello All, Is anyone doing any automations on Excel with VSTO or .Net. I have got few questions for you. Thanks.

Thanks Shrivallabha, The link http://spreadsheetpage.com/index.php/oddity/C39/ is quite informative about oddities in Excel. Now we can blame it one of those oddities, if you have a tough day with Excel. :p

Hi, You can try this formula by setting the Excel Calculation options to Manual. The drawback with this is, everytime you want to calculate the difference between Endtime and Start time you will have to go into each cell , edit and enter. Also, if you keep the Start time(Sheet1) and End...

Hi, Assuming that both Test1 and Test2 Excel files are open. Select/Group all the sheets on Test1 file and add this formula to the cell B36. =VLOOKUP(RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1),1)),[Test2.xlsx]Sheet1!$B$4:$C$7,2,FALSE)

Hi, Not sure how much will this help in your case, but if you want to show a bigger image on a cell, you can insert a comment and add an image into it. So, when mouseover the cell the comment appears with a full size image on it.

Hi Sushanta, I guess you cannot do this as the size of the images/iconsets have a pre-defined dimensions to make them fit into the cells and get binded to enlarge if the cell size increases. The traffic light icons are big enough to be identified on a cell. Do you have any other reason to...

Wonderful !!! Love this feature of adding images. "A picture is a worth 1000 words". This reduces the posts asking the members to upload the sample excel files for simple solutions. Thanks Chandoo & All. :)

Excited to see Chandoo in new AVATAR. Thank you.

OK.. slight change on the same function. Function SpellNumber(ByVal mynumber) Dim Pounds, Pence, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount...

Hi, Here you go. Replace the SpellNumber function with the below. Hope this resolves your issue. Function SpellNumber(ByVal MyNumber) Dim Pounds, Pence, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion "...

Hi, for Excel 2003 : Tools -> Options -> under "General" tab, change the text of UserName textbox. When you insert a new comment, the same text appears on the new comment. Excel 2007, 2010 : File -> Options -> General -> UsernameTextbox. All the best!!!

Hi, Thanks for highlighting the above. After reading the link again, I have few more questions for you : 1) Why do Excel 2010 lack the property to add these controls on worksheet? Any specific reason for it or do Excel force us to use only the Activex controls instead? 2) I never used...

Mother variable VARIANT, Thanks for forgiving me for my crappy code. You never stopped my code execution even when i dont know what am i writing.

Hi Narayan, Its the Form controls. Start Excel and go into the Developer tab, under Controls group, click on Insert. I can see two sections (Form Controls and ActiveX Controls). All the tools are enabled except last three under the Form Controls (those are Textbox, ComboList and ComboDropdown...

Hi Folks, I was playing around the form controls in Excel 2010 and noticed that only Textbox, ComboList and ComboDropdown controls are greyed out by default when I launch Excel. I am able to use the other form controls but only these 3 are disabled. I am with Office Professinal Plus 2010 with...

Hi Bob, Smallman, Thank you for writing on this post. I can't share the code as the compliance norms are very strict here and moreover it has got several modules, Form and a class modules. I am throwing a survey to the floor and the end users about the common charts they would expect which is...

Hi Madocar, Check if this file has got any links to external files. File opening/formula calculations generally make the file work very slow. Break those links if not required.

Hi, Here is another version to try on.. Sub expances_sheet2() Dim i As Integer On Error Resume Next Workbooks(".xlsm").Sheets("").Activate For i = 6 To 138 Select Case i Case 30, 36, 45, 50, 54, 63, 69, 91, 94, 133 Case Else...

Hi bobhc, Many thanks for writing on this. Sorry that I got busy with some urgent stuff and didn't get time to reply. Though the idea of "Sack one, get all done" drools me, unfortunately I will have to implement this for the management and I might stand first on the list if that so happens...

Hi All, We have a custom chart generator tool used in our organization to generate pre-defined chart types(that again basic charts) in specific colors, size etc., to keep it uniform across the regions, across different departments and people. All the basic charts are covered/available in...