Logo
Home Study Material Contact Search
AI Chat FREE
  1. engineering
  2. mechanical engineering
  3. write a vba code to convert an arbitrary positive

write a VBA code to convert an arbitrary positive binary fractional number (0< number<1) to equivalent...

50.1K

Verified Solution

Question

Mechanical Engineering

write a VBA code to convert an arbitrary positive binaryfractional number (0< number<1) to equivalent decimal number.the code should acquire the binary fraction number in theformat\"0.xxxxxx\"from input box, then return the equivalent decimalnumber in a message box. in the code, you may need to use VBAfunction \"mid(_,_,_)\" to pick up a specific symbols or charactersfrom a string. you can use below conversion as benchmark to verifyand debug your code:

(0.1011)2 = (0.6875)10

  

Answer & Explanation Solved by verified expert
4.3 Ratings (680 Votes)
Sub BinarytoDecimal Dim B B1 B2 As String Dim i A As Integer Dim A1 D As Double B    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

Graphical Analysis K Question 23 The cholesterol levels in milligrams per 154 156 165 165...

Physics
1.2K views

Please explain each and every option in detail also why fo rth is wrong 1...

Physics
1.2K views

Four capacitors each of capacitance C are connected as shown in the figure The ratio...

Geometry
1.2K views

What is the focus of the parabola y= 9x? Simplify any fractions. (____, ____)

Basic Math
1.2K views

Flag question Ayman Inc made a 25 000 sale on account with the following terms...

Algebra
1.2K views

Graph the equation y 3 2 x 2 5 3 4 2 1 Clear All...

Accounting
1.2K views

On January 1,2017 Haley Company had a balance of $360,000

Accounting
1.2K views

Required information [The following information applies to the questions displayed below.] Carlberg...

Accounting
1.2K views

Do you agree with the WSJs staff reporters assessment that As Ms. Vinson's experience...

Accounting
1.2K views

The Big Co. issued $100,000 of bonds for their face value six years ago. This...

Accounting
1.2K views

The following cost data pertain to the operations of Montgomery Department Stores, Incorporated, for the...

Accounting
1.2K views

Cost of Goods Sold, Profit margin, and Net Income for a Manufacturing Company The following...