Recent content by astrogirl77

Got it! Thank you! Will read the docs, thank you also for the link <3

Mikrom, thanks so much! <3 what exactly does the second line in your code above do?

Strongm, what would you recommend to get the best possible accuracy?

Hi Strongm, your code example works great as you described, what I found though after testing the routine against a high math precision python script was that they did not return the same values, found out the reason for this was that excel truncates at 15 digits whereas Python lets me set the...

Parsing Large Numbers Question Hi All, I am writing some simple code to raise a base value to a power then perform some operations on the output. I have included the code I am using now, below ( see end of this message ), also see immediately below what this looks like when I run my script...

Thanks to everyone above who gave me a hand! The code you shared with me - I got to work, but as was pointed out accuracy gets lost due to poor float handling. I tried a number of different approaches with numeric precision addin style tools but nothing worked well. Have a great day and...

Hi Strongmn! :) I tried the code you suggested and worked on this for quite a while but it wouldnt run for me it kept failing at the line ; SQRD = vbMod(SQRD / decx, ModVal) It kept saying "sub or function not defined" and highlighted "vbMod

Hi, I have been testing this code string and it was working great, until ... :( I tried to enter either a rational number for either the power to raise to, or for decx(divisor), so when I use (X)^2 and any integer for decx, no problem but if I try (X)^1.9999 and or decx = 1.0101, it returns...

Thank you so much! this totally solved the problem, I understand now what was wrong! You guys rock!!! Such a day maker! :) <3

Weird Math Error in VBA for Excel Hi all, would love feedback on unusual error I'm getting. Very strange. I have a simple formula that works great if I only use it in a normal sheet cell and copy it down by columns, but if I try to do a simple iteration in vba code to perform the same...

@gmmastros, Could you tell me, if I wanted to use a dbf file that was not all string fields, but instead field 1 was a string type, but the two other fields were numeric, float, etc.... how would I have to modify the code? Ive been tinkering with this also but ran into a few things that for a...

@ gmmastros - FINALLY! THAT DID IT!!!! THANK YOU SO MUCH, ITS WORKING NOW!!!!

@ ALL I am still not understanding why on the same computer, in the same environment, with essentially the same code, I CAN access and query the ninegrid dbf file (see attached above) just fine, but when I try to access the degreez dbf file I never can, its the SAME code basically, and I have...

@ dilettante, I tried to insert the code you sent into the GEneral declarations section, wasnt sure where else if should go... except the form load code, I put in in the form .... I got a bunch of errors back ; ................ Compile Errors ; Ambiguous Name detected; form_resize form_unload...

@dilettante, Im a newbie somewhat to VB programming but Im not lazy and am willing to put in effort to tinker and research, however I do not think I have the experience to easily identify which parts of your code I should chop out, would you feel comfortable if I asked you to edit out the parts...