Need macro for automatic point value insertion based on the number of answer choices selected

macropod · #1 08-01-2018, 06:02 AM

I think a little patience on your part wouldn't go astray. It also would have been helpful had you specified your requirements in full from the outset. So far you've made it like getting blood out of a stone... This should also have been posted as a follow-up in the original thread alone. Threads merged.

Change:
If .Range.Text = "X" Then j = j + 1
to:
If Trim(.Range.Text) <> "" Then j = j + 1

ganesang · #2 08-01-2018, 06:15 AM

I am really Sorry about that Paul!!

I don't think you working on this. That's why i just created again..

Also i never except to come another option (numeric value) in this code.

Once again my Apologies!!!

I will check on this and let you know..

Thanks much!!!

ganesang · #3 08-08-2018, 10:53 PM

Hi Paul!!!

The above modification code is not working for me.

Can you please check on this??

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cursor location on first click -- insertion point	stevec5088	Word	1	12-14-2016 02:45 PM
Move Insertion Point with VBA	Grasor	Word VBA	2	10-11-2016 08:50 PM
Need macro to fill data from different sheets based on selected item from drop down	skorasika	Excel Programming	1	03-13-2015 11:25 AM
Populate a table based on choices from drop down menu	Xaand	Word VBA	0	02-25-2014 11:08 AM
Insertion point not working	pmahoney14	Word	1	05-24-2012 04:17 PM