Question about Computers & Internet

1 Answer

Want to write a code in VBA for a Chart prepared in Excel

I have prepared a calculation chart in excel which calculates the steel in kgs required for the given pile.Since there are 6 different types piles with different steel requirement,i used if conditions to solve them in excel.But it is not sufficient,as I cannot write them in summary sheet.Now I calculate the steel in one sheet and then link in the summary,which consumes time,labor and is also error prone...Can you guys help me...I know I 'm being too optimistic on that score...

Posted by on

  • Rabins Sharma
    Rabins Sharma May 11, 2010

    Please mention all required details.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 183 Answers

Dear Customer,

you have not define your all details,

Plz give all details than & only than some can help you ,

so,Please mention all required details

THNX

Posted on May 17, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How can microsoft word help student to excel in their particular fields


Hi,
Microsoft Word is a part of Microsoft Office Software of inter-related desktop office applications. Word, Excel and Power Point are main and widely used applications, which I think equally beneficial for students as well as executives. In short, MS Word provides facilities like typing a letter, report, thesis etc. Excel is for calculation and Power Point is for presentations. I believe that MS Office is a very powerful and extremely beneficial software. So, I recommend that every student should learn using Office Suite and enjoy its benefits.

Let me know if any further clarification/ assistance is required.

Hope it helps! Good Luck! Thanks for using Fixya!
CreativeTECH

Sep 06, 2011 | Microsoft Windows XP Professional

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

1 Answer

How to create VBA programme in excel?


Use macro editor. And modify it.
You need to create a new Excel Based VB Program, then install Visual Basic 6.0 or higher version and use the MS Excel ActiveX control.

Aug 10, 2010 | Computers & Internet

1 Answer

Need Formula


TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

1 Answer

VBA Macro


Nice try! Find an upper-class student to give you one-on-one tutoring with your homework assignment.

Aug 26, 2008 | Computers & Internet

2 Answers

How to hide sheet tabs in MS Excel


Do you mean by Visual Basic / Macro?

if so this is what you need:

ActiveWindow.DisplayWorkbookTabs = False

Mar 07, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

121 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98868 Answers

David Payne
David Payne

Level 3 Expert

14086 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...