Code to add comments to selected cells within a selected range

[L. Howard]

Hi Howard,



Am Wed, 29 Jan 2014 13:18:35 -0800 (PST) schrieb L. Howard:






if you do it with a range you always get an error if you cancel the

inputbox.

The only way is working with a string but this string must be written.

It is not possible to do it by selecting with the mouse.

Have another look in SkyDrive. I changed the code and the prompt for the

inputbox.





Regards

Claus B.

--

Looking good, either way is fine for me, perhaps the mouse is quicker and easier for me, and I know now to avoid the error.

I suppose some folks prefer the keyboard as they are immensely adept with the keys.

Thanks.

Howard

 

[Claus Busch]

Hi Howard,

Am Wed, 29 Jan 2014 19:44:51 -0800 (PST) schrieb L. Howard:

Looking good, either way is fine for me, perhaps the mouse is quicker and easier for me, and I know now to avoid the error.

please look again in SkyDrive. It is now solved with another UserForm
with a RefEdit.


Regards
Claus B.

 

[L. Howard]

Hi Howard,



Am Wed, 29 Jan 2014 19:44:51 -0800 (PST) schrieb L. Howard:






please look again in SkyDrive. It is now solved with another UserForm

with a RefEdit.





Regards

Claus B.

--

Got it, that seems the most user friendly of all.

Thanks again.

Howard

 

[L. Howard]

Hi Howard,



Am Wed, 29 Jan 2014 19:44:51 -0800 (PST) schrieb L. Howard:

please look again in SkyDrive. It is now solved with another UserForm

with a RefEdit.





Regards

Claus B.

--

Hi Claus, my computer locked up and Excel crashed while toying with the last version of Deskbooking you posted on SkyDrive. I lost the version I had downloaded. The one with another Userform and a RefEdit.

I looked back into SkyDrive and the link to that workbook is gone.

Could you repost it please.

Thank, Howard

 

[Claus Busch]

Hi Howard,

Am Thu, 30 Jan 2014 12:05:17 -0800 (PST) schrieb L. Howard:

Could you repost it please.

done!
I also changed the upper part of the code in module2 (Charlie)
because the centeracrossselection not always worked correctly


Regards
Claus B.

 

[L. Howard]

Hi Howard,



Am Thu, 30 Jan 2014 12:05:17 -0800 (PST) schrieb L. Howard:






done!

I also changed the upper part of the code in module2 (Charlie)

because the centeracrossselection not always worked correctly





Regards

Claus B.

--

I noticed the centering thing, sorta inconsistent and annoying.

Thanks.
Howard

 

[Claus Busch]

Hi Howard,

Am Thu, 30 Jan 2014 13:38:40 -0800 (PST) schrieb L. Howard:

I noticed the centering thing, sorta inconsistent and annoying.

if the behaviour is not better now try it with merged cells and unmerge
them with "Reform"


Regards
Claus B.

 

[L. Howard]

Hi Howard,



Am Thu, 30 Jan 2014 13:38:40 -0800 (PST) schrieb L. Howard:






if the behaviour is not better now try it with merged cells and unmerge

them with "Reform"





Regards

Claus B.

--

Okay, it does seem to still crop up for no reason I can detect.

So you're saying instead of center across selection do merged cells instead and then unmerge them with the reform code.

I will give that a go.

Never thought I'd use merged cells in conjunction with code, but will do so on your advice.<bg>

Howard

 

[Claus Busch]

Hi Howard,

Am Thu, 30 Jan 2014 17:58:23 -0800 (PST) schrieb L. Howard:

So you're saying instead of center across selection do merged cells instead and then unmerge them with the reform code.

I avoid merged cells in tables because they are bringing problems with
sorting and filtering. But in this case it is more a graphic than a
table and I would try it.


Regards
Claus B.

 

[Claus Busch]

Hi Howard,

Am Thu, 30 Jan 2014 17:58:23 -0800 (PST) schrieb L. Howard:

I will give that a go.

please look again in SkyDrive.
The problem now is solved with merged cells. With "Delete" the cell will
be unmerged.
After merging the selection the problem is, that you have only 1 cell so
you can't choose more cells in the selection for adding comments :-(

I also merged Y1 with Z1 and AA1 that the cell is wide enough to show
the data validation entries without changing the column width and
display flickering. I deleted the Worksheet_SelectionChange event macro.


Regards
Claus B.

 

[L. Howard]

please look again in SkyDrive.

The problem now is solved with merged cells. With "Delete" the cell will

be unmerged.

After merging the selection the problem is, that you have only 1 cell so

you can't choose more cells in the selection for adding comments :-(



I also merged Y1 with Z1 and AA1 that the cell is wide enough to show

the data validation entries without changing the column width and

display flickering. I deleted the Worksheet_SelectionChange event macro.





Regards

Claus B.

--

That actually works quite well. One comment is probably enough.

I made some modifications to the cell/hours selection process, if only one or two cells selected then just the first initial of the selector is centered in the selection. If three or more, then the whole name.

Putting some finishing touches on the userforms to make a bit more presentable, then should be done.

Thanks for all the great guidance.

Howard