convert a listbox (focused) string value into an integer

O

OTWarrior

I am using 2 lisboxes to calculate a value, however, they don't seem to
calculate anything, I am guessing the drop down form fields are saving the
data as a string, therefore i need to change it into a number (some list data
is "15 mins", 1 hour, etc, so i would need to somehow use that select to
choose a different value)

Also, there are 2 listboxes per row (total of 14 rows) that will eventually
use this calculation, so is there also a way of making the "turnVal"
generalised using the bookmark, rather than writing a macro for each one?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top