vba - comments

Hi All, Complete newby to VBA and learning as i go. Someone helped me with my first VBA macro last week and now I'm hooked on improving my CRM system! What i need to do, is.... I have an orders sheet and a sales sheet; once an order is completed, it becomes a sale. I need the act of...

Dear Friends, I am trying to create Macro Program for my regular activity for Data Extracted from Tally. I am having cells filled with Amount as number and custom Formatted as ""0.00" Cr" and ""0.00" Dr" So Cell display will be D5 = 100 (Display as "100 Cr") and D6 = 150 (Display as "150...

Hello, I have a particular set of data: AA BB AB CC CA CD DA FA FD FC I want to create an if/then statement to delete all values that contain either an "A" or a "D" for purposes of eliminating irrelevant data. Sometimes I'll have more values, sometimes less, but I always want the same...

Want to understand: what Application.EnableEvents = FALSE does in the code. 1 of my Excel workbook contains multiple worksheets. In 4 worksheets, there are codes & all functioning properly. In a new inserted worksheet in the same Excel workbook, a code is to be pasted which contains...

Hello Friends, I am new in VBA and i want to develope one macro in which user will enter data and generate querry but when i am generating excel sheet that time one sheet is giving correct data but all other sheet has been corrupt automatically the code is given below...

I have an array of A1:F20, I want to subtract the values incolumn A from column F. <o:p></o:p> I am trying to see the connections (or process) how when yousee A1 immediately you think as range and so on, so in this little problemwhere is the <o:p></o:p> Objects, properties, procedures, events...

I would like someone really make clear the difference between methods and properties, showing some snippet code and using callout to pointout where is the method and where is the properties (and the objects, procedures and events as well) thanks.

the code is to create chart and but name, title, range, style and type for chart the code run well except type and style any idea Charts.Add With ActiveChart .HasTitle = True .ChartTitle.Text = Application.InputBox("Please enter chart Title", "Chart Title", "As of " &...

I am new to VB and am struggling to find a more elegant way of inserting comments into a range of cells (c2:d35) so have brute forced it. I would also like to autosize the comments but don't want to create this the same way as I have inserted the comments. Any help you can provide would be much...