Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

For John D Part 1 The current AdjustNumber Sub() routine…

Customer Question
For John D: Part 1: The current...
For John D:

Part 1:
The current AdjustNumber Sub() routine requires the user to:
1. Insert a row
2. End the correct number
3. Run the Adjust Number Macro

Assuming user has positioned cursor in the correct row,

Is it possible to have an Insert Row button that opens an input box asking for:
The level of insertion level (options 1, 2, 3, 4) and the description of the item.
User selects level 3 and "New assessment point" (3-4 line text box) and clicks OK
Adjust Number macro would:

Unprotect the worksheet
1) Insert the row
2) Determine and display the correct number sequence in columns A-F
3) copy the formula from the G column (active row - 1) and paste in active row.
4) Enter the text from the message entry in the H column
5) Run the sub zFormat on the inserted line (don't think any other lines will need it)
Place cursor in I column of active row
Protect the worksheet.

Part 2:
???New Sub to FixNumbering
of Modification of the Adjust Number code attached to a Fix/Verify the validity of the number system for the ENTIRE TABLE.

The end result could be either:
1) Fix it
or
2) Report through a message box that reports which rows are missnumbered and suggest that user fix them manually.
Submitted: 8 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 59 minutes by:
6/23/2010
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
Experience: Vast experience in Excel programming and business solutions
Verified

Hi Jim.

 

Went through the requirement quickly and all I can say at this point is that what you want to accomplish is quite clear, but I won't be able to tell you if it's all practically doable or not (especially Part 2) unless I actually start working on it. I can start on it around mid day tomorrow, and only then I will be able to give you a time frame for completion.

 

Would that be ok?

 

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
Yes. My deadline has been extended a day.
Customer reply replied 8 years ago

Hi John,

I thought that I would have heard from you by now. Are you still interested?

Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Jim, I am working on. I will be sending you in a short while the userform interface for inputing data so you can check it and let me know if it is ok.

Ask Your Own Programming Question
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Hi Jim,

 

Ok, this is data input part. Have a look at it and let me know if it needs anything

 

http://www.sendspace.com/file/z01nt4

 

Ask Your Own Programming Question
Customer reply replied 8 years ago

 

It did insert the line but didn't number so I must have interpreted the instructions wrong. My goal is to make inserting a new row as bullet-proof as possible since we don't have an undo that I'm aware of.

 

See my suggestions in this file and let me know if they need clarification.

 

http://www.sendspace.com/file/91xh2m

Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Jim, you are providing more or less the same information you gave me before. To keep reading technical instructions between the lines is time consuming and can be frustrating. I sent you a file with my understanding of your instructions. In order not to keep going in circles, you need to take it from there and comment specifically on my response so I can fine tune it and move on to the next phase.

 

Have to sign off now. Will be back later in the evening.

 

Thanks.

 

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask John D Your Own Question
John D
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Vast experience in Excel programming and business solutions

John D is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I want to write a macro that will move or copy a block of
I want to write a macro that will move or copy a block of cells from the current location to somewhere else in the worksheet without overwriting cells at the destination. ie. the macro will know the n… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
John, On the same form we have been working, there
John, On the same form we have been working, there is a button that says 'Go To'. When pressed, I can enter which row in the 'Data' worksheet to load onto the form. I don't need this. What I need is t… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I am writing a macro to search through a worksheet for a particular
I am writing a macro to search through a worksheet for a particular string, then insert a blank row. I want the routine to stop at the last instance of this string. I started by having the recorder re… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Hi Im stuck with on trying to get my macro to copy and insert
Hi I'm stuck with on trying to get my macro to copy and insert row at the begining of my sheet, I've written the formula to copy and past from another sheet… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I want to protect a sheet which has a table with some data
I want to protect a sheet which has a table with some data entry cells and a formula in the last column and I want new rows to be automatically added when you tab through the last row. However when I … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Hi guys - I am a complete newbie here, so please bare with
Hi guys - I am a complete newbie here, so please bare with me. I have created a report in excel which effectively consists of about 3000 lines of data. I need to develop that into a report which can b… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
It seems I could not properly express my question to my previous
It seems I could not properly express my question to my previous expert so let me try again. I have created a list using Excel 2003. It works as it should. If I click on any cell within the list a lin… read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
Load list reportsWe run a Sales by product report in
Load list reports We run a ‘Sales by product' report in Excel, this interrogates SAGE for the relevant data. We use this report as load list. In order to make it user friendly we make the same adjustm… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
Advanced excel. Got some help on this board before with a
Advanced excel. Got some help on this board before with a spreadsheet's macro's, and the help was excellent, but there were a few things the guy could not do that I need done: 1) A macro he gave me br… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Need a macro to copy rows showing the sub-totals in an Excel
Need a macro to copy rows showing the sub-totals in an Excel workbook by using a filter criteria to identify the sub-total rows and copying the selected sub-total rows to a different sheet within the … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
HELP!!! My client is in Thailand and found a problem with this
HELP!!! My client is in Thailand and found a problem with this module... For Bill Sprouse: I need a code modification in one of the four modules is a bit different and causing me issues. Instead of fo… read more
Bill Sprouse
Bill Sprouse
Bachelor\u0027s Degree
37 satisfied customers
Im a struggling beginning using macros that Ive written with
I'm a struggling beginning using macros that I've written with some assistance. I need some to review the code. If error trapping, DIM statements, etc. are needed, I would like you to do them. Please … read more
Bill Sprouse
Bill Sprouse
Bachelor\u0027s Degree
37 satisfied customers
I have a workbook with multiple sheets that I need to select
I have a workbook with multiple sheets that I need to select a 10 cell verticle number array from one sheet and transpose this array to horizontal then paste it into another sheet in a different locat… read more
Arty
Arty
Senior Administrator
Bachelor\u0027s Degree
469 satisfied customers
I have code for a Macro that inserts a new column if the number
I have code for a Macro that inserts a new column if the number 1 appears in a cell in the first row. How do I get it to repeat throughout the worksheet. It currently just gets to the first number "1"… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Sometimes you need to know which is the last column in an
Sometimes you need to know which is the last column in an Excel sheet that contains actual data. Can someone tell me how or give me the macro. I have read that some solutions require you to save your … read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Hi I have a spreadsheet which has multiple tabs. The information
Hi I have a spreadsheet which has multiple tabs. The information from each tab is summarised on another sheet within the spreadsheet. Each formula which I need to change manually is in the form of; =D… read more
Tony M
Tony M
Sr. Application Developer
Bachelor's Degree
54 satisfied customers
Ive got a macro to lock/unlock an entire worksheet but Id
I've got a macro to lock/unlock an entire worksheet but I'd like to modify it to lock/unlock only a certain portion of the worksheet. Can you help?… read more
Hirash Riyal
Hirash Riyal
Higher Diploma In IT
174 satisfied customers
I am very proficient in Excel and Lotus 123. However, I am
I am very proficient in Excel and Lotus 123. However, I am having trouble developing an Excel spreadsheet that is based on a LONG list of data which is set-up in Rows (say 100 Rows of data, each Row c… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x