vba: userform functions -


i have sub activated button on userform. basic procedure click

1) run sub based off of user inputs

2) select results sheet

3) display results

4) unload userform

i've run problem because want try , put bounds on user input value , if user inputs out of range message box pop notifying them of range. i've been able accomplish simple task through use of if/then loop. after user exits out of message box want keep userform displayed along original user inputs , allow user change input. after user clicks 'ok' on message box, click sub continues procedure , unloads userform , selects results worksheets. there simple 1 line code can put after msgbox state preserve userform instead of making user re-enter values?

edit - general gist of code follows:

private sub commandbutton1_click()     propertysearch.search     activesheet.name = "searchresult"     cells(1, 1).select     unload ilsearch end sub  sub search()     if (textbox1 , textbox2 <= 8) , (textbox1 , textbox2 > 0)     '     'performs desired function     '     else: msgbox ("database includes ionic liquids maximum of 8 carbons in cation")     end if

i turn search function returns true or false if input within bounds or not:

function search() boolean     if (textbox1 , textbox2 <= 8) , (textbox1 , textbox2 > 0)       search = true    else       search = false    endif  end function

then exit sub if input not meet bounds:

private sub commandbutton1_click()      if(not propertysearch.search)        msgbox("your error message here")        exit sub     endif      ' rest of routine  end sub

Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more