Reply to thread

Message

<blockquote data-quote="deleteme123456" data-source="post: 4396866" data-attributes="member: 65832">If it makes you feel better, I didn't know, but I looked for you. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" /> If you give your weapon a NAME under Attacks (by the attack bonus), for example, you could name your shortsword &quot;Sting&quot; or your longbow &quot;Steve's Longbow&quot; or your greataxe &quot;Axe of DOOM!!!&quot;, then these names will show up in the Weapon 1 dropdown.The weapon 2 and 3 fields are free entry (probably a bug to be corrected later). To the authors: These fields may also benefit from having the error message supressed (this feature could be used elsewhere in place of seperate override fields): In Excel 2003, go to Data -&gt; Validation and then click the Error Alert field and clear the checkbox. This will allow users to use the dropdown or type any other value they'd like. Another step I'd take with these is the create a separate list (hidden somewhere) that checks for blank weapon names and copies the weapon/implement choice as the option then. For example, if I have a Dagger but don't give it a name like &quot;Pointy Thing&quot;, then Dagger would be placed in this hidden list, and then use that hidden list for data validation purposes.</blockquote>

[QUOTE="deleteme123456, post: 4396866, member: 65832"] If it makes you feel better, I didn't know, but I looked for you. :) If you give your weapon a NAME under Attacks (by the attack bonus), for example, you could name your shortsword "Sting" or your longbow "Steve's Longbow" or your greataxe "Axe of DOOM!!!", then these names will show up in the Weapon 1 dropdown. The weapon 2 and 3 fields are free entry (probably a bug to be corrected later). To the authors: These fields may also benefit from having the error message supressed (this feature could be used elsewhere in place of seperate override fields): In Excel 2003, go to Data -> Validation and then click the Error Alert field and clear the checkbox. This will allow users to use the dropdown or type any other value they'd like. Another step I'd take with these is the create a separate list (hidden somewhere) that checks for blank weapon names and copies the weapon/implement choice as the option then. For example, if I have a Dagger but don't give it a name like "Pointy Thing", then Dagger would be placed in this hidden list, and then use that hidden list for data validation purposes. [/QUOTE]

Verification