Add loop and stop to Excel Macro -


no code experience. have excel file macro scan product bar-codes handheld scanner. have click "scan" every product. how add loop to:
* return start position when scanning complete
* stop when done scanning. add stop button file
info, below current macro i'd add loop , stop.

sub scanner_input()     dim myproduct string     dim lastrow object     myproduct = application.inputbox("please scan product code", "product        id", type:=1)     set lastrow = sheets("database").range("a65536").end(xlup)     lastrow         .offset(1, 2) = myproduct     end      end sub


Comments

Post a Comment

Popular posts from this blog

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

javascript - pass values from mssql to views in node -

being new node js , javascript . have been trying find solution problem . this app.js file var express=require ('express'); var bodyparser = require('body-parser'); var path = require ('path'); var sql = require('mssql'); var app = express(); const config = { user: 'sa', password: 'password', server: 'localhost\\sqlexpress', // can use 'localhost\\instance' connect named instance database: 'pcgdb', options: { encrypt: false // use if you're on windows azure } }; const request = new sql.request() //view engine app.set('view engine', 'ejs'); app.set('views', path.join(__dirname, 'views')) app.use(bodyparser.json()); app.use(bodyparser.urlencoded({extended: false})); app.get('/',function(req,res){ res.render('index') }); app.get('/new_project', function(req, res) { function(data,err){ ...
Read more

python - Getting 405 error while trying to download nltk data -

when try below code python -c "import nltk; nltk.download('punkt'); nltk.download('averaged_perceptron_tagger'); nltk.download('maxent_treebank_pos_tagger'); nltk.download('wordnet')" the console says [nltk_data] error loading punkt: http error 405: not allowed. [nltk_data] error loading averaged_perceptron_tagger: http error 405: [nltk_data] not allowed. [nltk_data] error loading maxent_treebank_pos_tagger: http error 405: [nltk_data] not allowed. [nltk_data] error loading wordnet: http error 405: not allowed. this caused down-age of github raw file link. meanwhile stop-gap solution manually download file: path_to_nltk_data=/home/username/nltk_data/ wget https://github.com/nltk/nltk_data/archive/gh-pages.zip unzip gh-pages.zip mv nltk_data-gh-pages/ $path_to_nltk_data we're working on finding alternative data , model downloading. meanwhile, @everyone please check script(s) , make sure you're not...
Read more